NTSB investigations, 1993, ID
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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\") = 1993
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") = 1993 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 SEA94FA034Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Mountain Home, IDThe pilot's intentional suicide and impairment from consumption of alcohol.NTSB SEA94LA033Accident · No injuriesLimited investigationFinal reportCessna C-172N · Idaho Falls, IDThe pilot's failure to attain the proper touchdown point. Factors include tailwind conditions and an airport perimeter fence.NTSB SEA94LA028Accident · No injuriesLimited investigationFinal reportCessna 320C · Spirit Lake, IDThe pilot's failure to maintain airspeed. The pilot's failure to maintain directional control was a factor.NTSB SEA93LA209Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA 315B · Avery, IDThe pilot's improper use of the cyclic control.NTSB SEA93LA207Accident · No injuriesLimited investigationFinal reportBell UH-1B · Pierce, IDSeparation of the 90 degree gearbox after fatigue failure of the gearbox attach bolts. Factors include hilly/mountainous terrain.NTSB SEA93FA206Accident · 1 fatalField investigationFinal reportCessna 180B · Mullan, IDThe pilot's poor in flight decision, and his inadvertent continuation of a VFR flight into instrument meteorological conditions. Factors include low ceilings, snow, fog, rain, and mountainous/hilly terrain.NTSB SEA93LA192Accident · No injuriesLimited investigationFinal reportWestholm Vans RV-6 · Salmon, IDThe inadequate preflight planning/preparation by the PIC in his failure to close the fuel drain valve. A factor relating to the accident was the fence post located in the landing area.NTSB SEA93FA194Accident · 1 fatalField investigationFinal reportCessna 182D · Lucile, IDThe pilot's failure to maintain airspeed resulting in an aerodynamic stall. The mountainous terrain was a factor.NTSB SEA93LA190Accident · No injuriesLimited investigationFinal reportCessna 182L · Idaho Falls, IDThe encounter with unfavorable wind during landing roll and the pilot's failure to maintain directional control.NTSB SEA93FA186Accident · No injuriesField investigationFinal reportDassault DA-10 · Hailey, IDThe pilot-in-command's improper procedures. Factors include failure of an electrical relay, inoperative thrust reverser, poor crew coordination, and the second-in-command's improper procedures.NTSB SEA93LA184Accident · No injuriesLimited investigationFinal reportCessna 206B · Challis, IDInadequate compensation for wind conditions. The downdraft was a factor.NTSB SEA93FA179Accident · 1 fatalField investigationFinal reportCessna 172N · Lake Fork, IDPoor judgment of the pilot by flying while under the influence of alcohol and a drug, his continued flight into an area of adverse weather, and his failure to maintain adequate clearance (or altitude) from mountainous terrain. Factors related to the accident…NTSB SEA93LA176Accident · No injuriesLimited investigationFinal reportCessna 185C · Stibnite, IDLeakage of hydraulic brake fluid and improper maintenance by the pilot in command. A factor contributing to the accident was inadequate inspection by the mechanic.NTSB SEA93LA170Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Yellow Pine, IDThe pilot's improperly planned approach and delayed remedial action. A factor related to the accident was: the proximity of mountainous terrain.NTSB ANC93FA128Accident · No injuriesField investigationFinal reportConvair 240 · Boise, IDThe pilot's failure to extend the landing gear, and the check pilot's inadequate supervisiion. A factor in the accident was the pilot's inadequate upgrade training by the company.NTSB SEA93LA160Accident · Serious injuriesLimited investigationFinal reportCessna 337 · Jerome, IDThe pilot's improper fuel management procedures which resulted in fuel starvation. Factors include the pilot's lack of familiarity with this type aircraft, and rough/uneven terrain in the landing area.NTSB SEA93LA155Accident · Serious injuriesLimited investigationFinal reportBeech 60 · Fairfield, IDThe pilot's improper inflt planning/decision in selecting the wrong runway for landing. A factor relating to the accident was the strong tailwind weather conditions.NTSB SEA93LA122Accident · No injuriesLimited investigationFinal reportCessna TU206G · Mountain Home, IDCompensation for wind conditions was inadequate. The wind gusts were a factor.NTSB SEA93LA120Accident · No injuriesLimited investigationFinal reportCessna 185A · Lowell, IDFatigue of the rocker arm and unsuitable terrain which was encountered during the precautionary landing.NTSB SEA93LA115Accident · No injuriesLimited investigationFinal reportLarkin Pitts Special · Nampa, IDThe pilot failed to maintain directional control during landing ground roll.NTSB SEA93LA114Accident · No injuriesLimited investigationFinal reportMaule M-4-210C · Moscow, IDThe inadequate visual lookout by the pilot and his failure to maintain clearance from electrical transmission wires. Factors relating to the accident were the sunglare and the presence of the wires.NTSB SEA93LA080Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Hailey, IDThe pilot in command's failure to maintain directional control. A factor contributing to the accident was the snowbank.NTSB SEA93LA077Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Burley, IDLanding on the wrong runway and an improper touchdown. Lack of total experience in type of operation was a factor.NTSB SEA93LA060Accident · No injuriesLimited investigationFinal reportCessna 206G · Keuterville, IDThe pilot's inadequate visual lookout. Factors include a power line in the vicinity of the airstrip.NTSB SEA93LA057Accident · No injuriesLimited investigationFinal reportCessna 180E · Riggins, IDThe improper preflight planning by the pilot and his failure to attain proper airspeed for takeoff from a short strip in tailwind weather conditions. A factor relating to the accident was the tailwind weather conditions.NTSB SEA93GA049Accident · No injuriesFinal reportPiper PA-18-135 · Council, IDThe pilot's failure to maintain proper altitude during the low pass. The snow covered terrain and the pilot's inadequate preflight preparation were factors.