NTSB investigations, ID
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, newest first
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 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 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 SEA94FA123Accident · 2 fatalField investigationFinal reportBellanca 8GCBC · Challis, IDThe pilot's failure to maintain clearance from terrain.NTSB SEA94FA106Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Kellogg, IDFailure of the pilot to maintain aircraft control, due to spatial disorientation, while flying with partial panel, and the design stress limits of the aircraft being exceeded. Factors related to the accident were: failure of the vacuum system, which resulted…NTSB SEA94LA107Accident · No injuriesLimited investigationFinal reportRich RV-4 · Weston, IDThe pilot's failure to use carburetor heat. Factors include carburetor icing conditions, and no suitable site for a forced landing.NTSB SEA94LA093Accident · No injuriesLimited investigationFinal reportCessna 210D · Cobalt, IDThe pilot selected unsuitable terrain for landing. Factors in the accident were: the wet runway and rising terrain that precluded a go-around.NTSB SEA94LA090Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Driggs, IDDirectional control was not maintained. A factor to the accident was: inadequate remedial action.NTSB SEA94LA081Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Dubois, IDThe pilot's inadequate visual lookout. Factors include light conditions at dusk.NTSB SEA94LA075Accident · No injuriesLimited investigationFinal reportCessna 175A · Stanley, IDThe pilot's failure to maintain the proper descent rate. Factors include downdrafts on final approach.NTSB SEA94LA066Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Nampa, IDThe pilot in command's failure to refuel the aircraft. Factor(s) contributing to the accident were: fuel exhaustion, lack of total experience in type aircraft, and terrain condition (ditch).NTSB SEA94FA062Accident · 1 fatalField investigationFinal reportCessna T210N II · Emmett, IDAn inadvertent stall. Factors contributing to the accident were fuel exhaustion and the tailwind.NTSB SEA94FA052Accident · 1 fatalField investigationFinal reportPiper PA-12 · Idaho Falls, IDThe pilot's failure to maintain clearance from the terrain. Factors include the pilot's poor inflight decision to attempt low level maneuvers in a narrow canyon.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.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.