NTSB investigations, 1990, ID
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1964 | 70 |
|---|---|
| 1965 | 49 |
| 1966 | 62 |
| 1967 | 64 |
| 1968 | 65 |
| 1969 | 47 |
| 1970 | 54 |
| 1971 | 57 |
| 1972 | 41 |
| 1973 | 48 |
| 1974 | 63 |
| 1975 | 56 |
| 1976 | 63 |
| 1977 | 48 |
| 1978 | 43 |
| 1979 | 56 |
| 1980 | 44 |
| 1981 | 40 |
| 1982 | 47 |
| 1983 | 41 |
| 1984 | 41 |
| 1985 | 46 |
| 1986 | 50 |
| 1987 | 25 |
| 1988 | 29 |
| 1989 | 22 |
| 1990 | 30 |
| 1991 | 30 |
| 1992 | 37 |
| 1993 | 26 |
| 1994 | 39 |
| 1995 | 35 |
| 1996 | 33 |
| 1997 | 31 |
| 1998 | 41 |
| 1999 | 46 |
| 2000 | 34 |
| 2001 | 24 |
| 2002 | 48 |
| 2003 | 52 |
| 2004 | 40 |
| 2005 | 38 |
| 2006 | 30 |
| 2007 | 40 |
| 2008 | 34 |
| 2009 | 37 |
| 2010 | 37 |
| 2011 | 33 |
| 2012 | 40 |
| 2013 | 32 |
| 2014 | 30 |
| 2015 | 27 |
| 2016 | 22 |
| 2017 | 31 |
| 2018 | 28 |
| 2019 | 33 |
| 2020 | 24 |
| 2021 | 39 |
| 2022 | 27 |
| 2023 | 29 |
| 2024 | 35 |
| 2025 | 22 |
| 2026 | 19 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE year(c.\"eventDate\") = 1990
AND c.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE year(c."eventDate") = 1990 AND c."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB SEA90FA079Accident · No injuriesField investigationFinal reportBell 206B-3 · Coeur D'Alene, IDFailure of the pilot-in-command (PIC) to maintain rotor RPM, and a delay by the FAA inspector (flight examiner) in taking remedical action.NTSB SEA91LA033Accident · 1 fatalLimited investigationFinal reportErco 415-C · Ola, IDThe pilot's failure to maintain sufficient altitude for terrain clearance. Also causal was the pilot's impairment due to alcohol. Contributing factors were the night light condition and the hilly terrain.NTSB SEA91LA024Accident · Minor injuriesLimited investigationFinal reportCessna 182L · Kamiah, IDThe pilot's inadequate compensation for the wind conditions.NTSB SEA91FA021Accident · 3 fatalField investigationFinal reportBeech 95-55 · Hayden Lake, IDThe pilot's improper IFR procedure in failing to intercept the proper glideslope path.NTSB SEA91FA020Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Albion, IDThe pilot-in-command's failure to maintain control of the airplane in instrument meteorological conditions. Factors which contributed to the accident were the pilot's apprehension of flying in the forecasted weather, and the adverse weather conditions…NTSB SEA91LA017Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Boise, IDThe pilot's delaying remedial action after a poor landing approach.NTSB SEA91LA014Accident · No injuriesLimited investigationFinal reportCessna 402B · Pocatello, IDThe loss of engine power due to a burned piston resulting from arcing and partial failure of the left magneto because of improper overhaul, the contamination of the right magneto and improper adjustment of the fuel system at the last major engine overhaul;…NTSB SEA91LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Blackfoot, IDThe pilot did not adequately recover from a bounced landing. Factors were improper airspeed and lack of total expereince.NTSB SEA91FA144Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Mullan, IDThe pilot's VFR flight into instrument meteorological conditions (IMC). The adverse weather and terrain conditions were related factors.NTSB SEA90LA196Accident · Minor injuriesLimited investigationFinal reportBeech C-45H · Twin Falls, IDThe pilot's inability to maintain directional control during a takeoff in strong crosswind conditions.NTSB SEA90LA177Accident · No injuriesLimited investigationFinal reportCessna 172M · Lewiston, IDThe failure of a nose landing gear fork, which resulted in the pilot's loss of directional control, and a nose-over after an excursion from the runway.NTSB SEA90LA156Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-10-10 · Coeur D'Alene, IDPassenger spilling a hot cup of coffee in her lap while the flight was in cruise flight.NTSB SEA90LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Island Park, IDImproper planning/decision by the pilot. The high density altitude and the pilot's overconfidence in the aircraft's ability were related factors.NTSB SEA90LA123Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Worley, IDImproper planning/decision by the pilot, which resulted in an inadequate supply of fuel and fuel exhaustion. The high vegetation (wheat crop) and rough terrain (rut) were related factors.NTSB SEA90LA120Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Island Park, IDPilot's failure to maintain directional control, while attempting a soft-field takeoff. The crosswind was a related factor.NTSB DEN90FA149Accident · 2 fatalField investigationFinal reportTaylorcraft BC 12-D · Homedale, IDThe failure of the pilot to maintain adequate airspeed during maneuvers (buzzing) which resulted in an inadvertent stall of the aircraft. A factor was the intentional buzzing of family members.NTSB SEA90LA111Accident · Minor injuriesLimited investigationFinal reportCallair A-3 · Burley, IDAn encounter with meteorological conditions that exceeded the aircraft's ability to climb or maintain level flight. The high density altitude and lack of suitable terrain were factors related to the accident.NTSB SEA90LA110Accident · No injuriesLimited investigationFinal reportCessna 340A · Priest River, IDThe pilot's misjudgement of distance and altitude and his failure to maintain an adequate airspeed during the landing approach.NTSB SEA90LA105Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Jerome, IDThe pilot did not maintain a proper altitude while maneuvering to reverse direction.NTSB DEN90FA135Accident · 2 fatalField investigationFinal reportCessna TU206G · Challis, IDThe pilot's entry into an excessive maneuver after takeoff with insufficient altitude and airspeed to complete the maneuver, which resulted in a stall/mush into trees. Factors related to the accident were: high density altitude and trees.NTSB SEA90FA100Accident · 2 fatalField investigationFinal reportChampion 7KCAB · Pocatello, IDThe instructor pilots poor judgement in performing low altitude steep turn maneuvers resulting in an inadvertant stall at an altitude too low for recovery. Factors in the accident were the over gross weight and out-of-cg aircraft loading, and strong gusty…NTSB SEA90LA093Accident · No injuriesLimited investigationFinal reportCessna TU206G · Elk City, IDThe pilot did not maintain directional control of the airplane during the landing roll. The landing was made on a wet runway with excessive airspeed.NTSB SEA90LA097Accident · Minor injuriesLimited investigationFinal reportRockwell S2R · Cottonwood, IDThe loss of engine power due to undetermined reasons. The berm, which the airplane struck during landing, was a factor in the accident.NTSB SEA90FA086Accident · 3 fatalField investigationFinal reportRockwell Commander 114 · Atlanta, IDPoor preflight planning premature lift-off on takeoff by the pilot in command.NTSB SEA90FA080Accident · 1 fatalField investigationFinal reportSwearingen SA226-T(B) · Coeur D'Alene, IDInadequate coordination between the pilot and the ground lineman. A factor related to the accident was: impairment of the ground lineman from consumption of alcohol.NTSB SEA90LA076Accident · 1 fatalLimited investigationFinal reportPiper PA-18-125 · Rogerson, IDThe pilot's intentional flight below safe altitudes while engaged in low-altitude 'buzzing' activities.NTSB SEA90LA068Accident · 1 fatalLimited investigationFinal reportTruckee Meadows Tierra II · Moscow, IDThe pilot did not maintain a proper airspeed during the climb to cruise.NTSB SEA90LA061Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Boise, IDPilot did not maintain directional control of the airplane during the landing roll.NTSB SEA90LA037Accident · No injuriesLimited investigationFinal reportSwearingen SA226TC · Coeur D'Alene, IDThe loss of the flight crew's visual perception, due to an unforeseen whiteout condition. A related factor was the snowbank.NTSB SEA90LA035Accident · 1 fatalLimited investigationFinal reportStanger Aircommander 532 · Hansen, IDFailue of the pilot to maintain control of the gyrocopter after entering an abrupt pull-up from a low pass. Factors related to the accident were: failure of the pilot to follow procedures/directives, his lack of certification (qualification) for this flight,…