NTSB investigations, 1992, 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
Latest 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\") = 1992
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") = 1992 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 SEA93LA044Accident · No injuriesLimited investigationFinal reportCessna 414A · Rexburg, IDThe pilot did not select the remaining fuel supply. Factors include a deteriorated fuel selector valve.NTSB SEA93FA040Accident · Serious injuriesField investigationFinal reportDassault-Breguet Falcon 10 · Mccall, IDThe failure of the flight crew to follow the checklist and release the parking brake before takeoff. The inoperative parking brake warning light and the failure of the pilot to abort the takeoff were factors.NTSB SEA93LA038Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Arco, IDA leaking crankshaft oil seal, and snow on the landing area.NTSB SEA93LA037Accident · No injuriesLimited investigationFinal reportMaule M5-180C · Garden Valley, IDInadequate preflight planning and preparation. Factors include the snow covered runway.NTSB SEA93LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA-46 · Twin Falls, IDThe pilot's failure to maintain the ILS glide path.NTSB SEA93LA034Accident · No injuriesLimited investigationFinal reportBell 47G3-B2A · Montpelier, IDThe loss of engine power due to leaking internal carburetor seals, resulting from improper repair of the carburetor by an acft repair station.NTSB SEA93FA031Accident · 1 fatalField investigationFinal reportBeech S35 · Rexburg, IDThe pilot in command's failure to maintain clearance with objects/terrain. Factors contributing to the accident were low ceilings, snow, dark night conditions, trees, improper preflight planning and self induced pressure.NTSB SEA93FA023Accident · 3 fatalField investigationFinal reportCessna T207A · Elk City, IDThe pilot's continuation of a VFR flight into instrument meteorological conditions. Factors include becoming lost, disoriented, falling snow, and mountainous, hilly terrain.NTSB SEA93FA020Accident · 1 fatalField investigationFinal reportCessna T210R · Boise, IDProper altitude was not maintained. Factors to the accident were: fog, dark night conditions, and improper IFR procedures.NTSB SEA93FA018Accident · 2 fatalField investigationFinal reportMaule M5 · Challis, IDThe pilot continued the VFR flight into IMC weather conditions. Factors relating to the accident were the snow and obscuration weather conditions, inadequate preflt planning/preparation by the pilot in command, and the mountainous terrain.NTSB SEA93LA014Accident · No injuriesLimited investigationFinal reportCessna 182A · Ashton, IDA power loss for undetermined reasons. A factor contributing to the accident was the soft terrain.NTSB SEA93FA010Accident · 2 fatalField investigationFinal reportPiper PA-12 · Lowman, IDThe pilot's failure to maintain adequate terrain clearance. Factors include mountainous/hilly terrain, trees, and the pilot's diverted attention.NTSB SEA93LA008Accident · No injuriesLimited investigationFinal reportJames R. Prideaux Avid Flyer · Mt. Home, IDDirectional control was not maintained. A factor to the accident was: a tail wind.NTSB SEA92LA214Accident · No injuriesLimited investigationFinal reportCessna 320B · Lowell, IDRam induction air starvation of both engines and inability of the pilot in command to clear trees during the forced landing. Factors contributing to the accident were low ceilings and trees.NTSB SEA92LA200Accident · Minor injuriesLimited investigationFinal reportYork Y2 · Mountain Home, IDThe pilot's failure to maintain directional control. Factors include gusty crosswinds.NTSB SEA92LA192Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Blackfoot, IDThe pilot's failure to use proper airspeed for takeoff, resulting in loss of control during initial climb. Factors relating to the accident were the high da weather conditions, power line obstructions and a highway with a dirt bank at the end of the runway.NTSB SEA92LA180Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Pocatello, IDAn undetermined loss of engine power. A factor to the accident was: an in flight planning/decision delay.NTSB SEA92LA174Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Paul, IDThe pilot's selection of unsuitable terrain. The soft terrain was a factor.NTSB SEA92T#A04Accident · No injuriesClass 3Final reportBell 205A-1 · Arco, IDNTSB SEA92LA162Accident · No injuriesLimited investigationFinal reportKaman HH-43F · Headquarters, IDFuel exhaustion and the pilot in command's delay in refueling.NTSB SEA92FA161Accident · 1 fatalField investigationFinal reportCessna 172I · Donnelly, IDThe pilot's failure to maintain airspeed after takeoff while using improper obstacle takeoff procedures. Factors include excessive flap extension.NTSB SEA92LA158Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Burley, IDFuel exhaustion when anticipated fuel consumption was not adequately calculated.NTSB SEA92LA157Accident · No injuriesLimited investigationFinal reportCessna A188B · Twin Falls, IDThe pilot's failure to refuel resulting in fuel exhaustion and the unsuitable terrain encountered during the forced landing.NTSB SEA92LA152Accident · Minor injuriesLimited investigationFinal reportHiller-Soloy UH12D · Loman, IDFuel exhaustion. Factors include a short in the fuel quantity sensor/transmitter, an inadequate preflight, and a tree covered landing area.NTSB SEA92FA154Accident · 2 fatalField investigationFinal reportBeech 58 · Pierce, IDInflight loss of control when aircraft control was not maintained. Factors to the accident were: flight into known adverse weather and thunderstorm activity.NTSB SEA92LA145Accident · No injuriesLimited investigationFinal reportAvian Balloon Magnum IX · Driggs, IDThe pilot in command's failure to insure adequate clearance. Factors contributing to the accident were: weather condition (downdraft) and object (transmission wires).NTSB SEA92LA142Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Paul, IDLoss of engine power for undetermined reasons and aircraft control not possible by the pilot in command. A factor contributing to the accident was: rough/uneven terrain.NTSB SEA92LA132Accident · No injuriesLimited investigationFinal reportCessna 210D · Burley, IDThe pilot's inadequate visual lookout. Factors include FAA NOTAMS not being obtained, flight service station services not being used, and an object (temporary barrier) on the runway.NTSB SEA92LA115Accident · No injuriesLimited investigationFinal reportCessna 182Q · Mccall, IDThe pilot's poorly planned approach which resulted in a long landing and overrun of the runway.NTSB SEA92LA119Accident · No injuriesLimited investigationFinal reportMooney M20K · Stanley, IDThe failure of the pilot to maintain runway alignment and his loss of directional control during takeoff ground roll, resulting in a swerve off the 150 ft wide runway and impact with a fence. Factors relating to the accident were the lack of runway lights,…NTSB SEA92FA109Accident · 1 fatalField investigationFinal reportCessna 172L · Colburn, IDThe pilot became lost/disoriented, failed to maintain airspeed when he attempted to reverse course in a box canyon, and the aircraft stalled. Factors relating to the accident were the narrow box canyon, the high density altitude, and the lack of mountain…NTSB SEA92LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Chubbuck, IDInadequate preflight planning/preparation. A factor to the accident was: a guy wire.NTSB SEA92LA093Accident · No injuriesLimited investigationFinal reportAviat A-1 · Arco, IDThe pilot's inadequate compensation for wind conditions resulting in failure to maintain directional control. Factors contributing to the accident were: crosswinds and gusts.NTSB SEA92LA086Accident · No injuriesLimited investigationFinal reportCessna 182B · Dixie, IDThe pilot's inadequate compensation for the wind conditions. Factors relating to the accident were the high density attitude and the downdraft.NTSB SEA92LA085Accident · No injuriesLimited investigationFinal reportCessna 150G · Caldwell, IDThe pilot in command's failure to maintain directional control. Factors contributing to the accident were: crosswinds and gusts.NTSB SEA92LA054Accident · Serious injuriesLimited investigationFinal reportMichael Conner Avid Flyer · Nampa, IDThe pilot's inadequate weather evaluation. A factor in the accident was the unfavorable wind.NTSB SEA92LA048Accident · No injuriesLimited investigationFinal reportCessna 172P · Nordman, IDThe pilot selected unsuitable terrain. Factors contributing to the accident were: the snow covered runway, and the pilot in command's inadequate preflight planning.