NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 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 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 DEN93LA096Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Timpson, TXThe pilot in command's failure to refuel resulting in fuel exhustion. Factors were: the lack of suitable terrain for the forced landing, and dark night light conditions.NTSB DEN93FA097Accident · 1 fatalField investigationFinal reportCessna 172M · Clines Corners, NMThe pilot's failure to maintain a safe and proper altitude. Factors were the pilot's failure to obtain a preflight weather briefing, dark night condition, and weather conditions that included obscuration, fog, and drizzle.NTSB ATL93LA140Accident · No injuriesLimited investigationFinal reportCessna 172M · Manteo, NCInadequate compensation for wind conditions by the pilot. Factors related to the accident were: the adverse wind and the pilot's failure to obtain a weather briefing (inadequate weather evaluation).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 MIA93IA168Incident · No injuriesIncident investigationFinal reportBoeing 707-341 · Miami, FLThe improper inspection of the engine core cowling, which resulted in fatigue cracks in the forward inboard hinge support structure to go undetected. This resulted in the hinge separating and the cowling separating in flight.NTSB DEN93LA098Accident · No injuriesLimited investigationFinal reportBoeing 757-222 · Denver, COThe first officer's improper recovery from a bounced landing. Factors were: the first officer's delayed initiation of the flare, and the captain's improper supervision of the flight.NTSB CHI93LA304Accident · No injuriesLimited investigationFinal reportPiper PA-31P · Coffeyville, KSUndetermined.NTSB CHI93LA292Accident · No injuriesLimited investigationFinal reportCessna 152 · Marion, IAthe failure of the pilot to refuel prior to fuel exhaustion.NTSB CHI93DCD03Accident · 1 fatalFinal reportHoward W. Dutton Glas AIR II RG · Mt. Pleasant, IAthe pilot-in-command's not maintaining aircraft control.NTSB ATL93LA139Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Moncks Corner, SCFailure of the number one cylinder at the cylinder flange radius.NTSB ANC93T#A03Accident · No injuriesClass 3Final reportDe Havilland DHC-2 · Samsing Cove, AKNTSB ANC93LA131Accident · Minor injuriesLimited investigationFinal reportCessna 208 · Kodiak, AKThe pilot in command did not use the airplane checklist. A factor was his diverted attention to other mission related activities.NTSB SEA93LA169Accident · No injuriesLimited investigationFinal reportHadaller Murphy Renegade · Guernsey, WYImproper planning/decision by the pilot. Factors related to the accident were: rising/mountainous terrain, high density altitude, the lack of climb performance information available to the pilot, and rough/uneven terrain in the emergency landing area.NTSB SEA93LA168Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Ephrata, WAInadequate visual lookout by both pilots, resulting in their failure to see-and-avoid each other's aircraft. A factor related to the accident was: failure of the Grumman 164B pilot to adequately monitor the UNICOM frequency.NTSB NYC93LA143Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 7-15 · Milford, NHUnfavorable winds during landing which resulted in a hard landing and one passenger sustaining a broken angle.NTSB FTW93LA225Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Osceola, ARInadvertent stall. Factors were the improper latching of the engine cowling by the pilot and his inadequate preflight inspection.NTSB FTW93LA224Accident · No injuriesLimited investigationFinal reportCessna 150M · Bald Knob, ARFuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW93LA223Accident · No injuriesLimited investigationFinal reportBeech 35-33 · Guymon, OKThe pilot's inadequate compensation for wind conditions. Factors were windshear and gusty crosswinds.NTSB CHI93LA301Accident · 1 fatalLimited investigationFinal reportCessna 180 · Naubinway, MIThe pilot's improper flare for landing. Factors associated with the accident are the low clouds and fog, the rough water at the landing site, and the pilot's continued flight into known adverse weather.NTSB CHI93FA296Accident · Serious injuriesField investigationFinal reportGrumman G58A · Oshkosh, WIThe pilot-in-command's inadvertent use of the mixture resulting in a lean mixture.NTSB CHI93DCQ02Accident · No injuriesFinal reportCessna 188 · Buhler, KSthe loss of engine power due to a fractured accessory (camshaft) drive gear.NTSB ATL93LA141Accident · No injuriesLimited investigationFinal reportCessna 150F · Wilmington, NCA hidden soft spot on the runway that resulted in a nose over of the airplane during a landing roll.NTSB ATL93LA138Accident · No injuriesLimited investigationFinal reportMolino PIK-20 · Jonesville, NCThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin.NTSB ANC93LA133Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Soldotna, AKThe pilot's failure to attain a proper touchdown point. A factor was the pilot's improper in flight planning/decision.NTSB ANC93LA132Accident · No injuriesLimited investigationFinal reportCessna 180 · Sparrevohn, AKThe pilot's failure to maintain directional control of the airplane. A factor was the animal on the runway.NTSB ANC93LA129Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's improper planning/decision, while on an approach to land behind another airplane.NTSB MIA93WA167Accident · 4 fatalForeign investigationPiper PA-23-250 · Marsh Harbor, BahamasNTSB LAX93LA312Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fresno, CAThe pilot's inadequate flare and his improper recovery from the resulting bounced landing. Factors related to this accident were the alternator failure and the night condition.NTSB LAX93LA310Accident · Minor injuriesLimited investigationFinal reportNall Varieze · Newark, CAImproper annual inspection performed by other maintenance personnel. Factors relating to this accident were the loose exhaust bolts.NTSB LAX93FA311Accident · 3 fatalField investigationFinal reportRobinson R44 · El Monte, CAFatigue failure of the cyclic control (stick) assembly, which resulted in loss of cyclic (pitch & roll) control.NTSB FTW93LA221Accident · No injuriesLimited investigationFinal reportBoeing B75-N1 · Burnet, TXInadvertent groundloop by the pilot.NTSB FTW93FA222Accident · Serious injuriesField investigationFinal reportHarral Glasair 1 · Rusk, TXThe pilot's failure to select the proper fuel tank which resulted in a fuel starvation engine power loss and his inadvertant entry into a stall during the ensuing forced landing.NTSB DEN93LA094Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Corpus Christi, TXAn inadvertent stall. A factor was the pilot's intentional buzzing at low altitude over the beach.NTSB DEN93LA092Accident · Minor injuriesLimited investigationFinal reportCessna A150M · Galveston, TXThe disconnection of the throttle linkage and the resultant power loss. A factor was the lack of suitable terrain for the forced landing.NTSB CHI93LA307Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Excelsior Spgs, MOthe private pilot's failure to maintain adequate aircraft control during landing.NTSB CHI93LA305Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B · Clarinda, IAThe commercial pilot's failure to maintain adequate clearance from obstacles during aerial application maneuvers.NTSB CHI93LA295Accident · Minor injuriesLimited investigationFinal reportGardner SEA RAY · Oshkosh, WIThe pilot in command's not maintaining proper climb rate. A factor was the abrupt control interference by the passenger.NTSB BFO93LA143Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Danielson, CTUndetermined.NTSB ANC93LA143Accident · 2 fatalLimited investigationFinal reportArtic S-1B2 · Johnson Glacier, AKThe pilot's attempted flight in an airplane which exceeded the maximum allowable weight. The high mountainous terrain was a factor.NTSB MIA93LA166Accident · No injuriesLimited investigationFinal reportCessna 414 · Lake City, FLThe failure of the pilot-in-commmand to properly flare before touchdown and the pilot's decision to land with excessive airspeed. A contributing factor was the aprehension/anxiety of the pilot during the precautionary landing.NTSB LAX93LA309Accident · 1 fatalLimited investigationFinal reportCessna 182P · Dayton, NVThe pilot's failure to maintain an altitude sufficient to clear terrain due to alcohol and drug impairment.NTSB LAX93LA308Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Verdi, NVThe instructor's improper supervision of the flight; the dual student's improper in-flight decision to follow another helicopter on departure and the dual students delay in correcting the inadvertent yaw. Factors related to this accident was the inadvertent…NTSB FTW93LA227Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Harrison, ARAn inadvertent groundloop by the pilot.NTSB FTW93LA220Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Elaine, ARThe pilot's failure to maintain clearance of water spraying and the resultant power loss. A factor was unsuitable terrain for the forced landing.NTSB DEN93LA095Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Pagosa Springs, COThe decision by the pilot in command to fly at an altitude insufficient for the surrounding terrain. Factors were: the pilot's attention being momentarily diverted and the airplane's climb performance being exceeded.NTSB DEN93LA093Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Brookland, ARThe pilot's failure to maintain adequate object clearance.NTSB DEN93LA091Accident · No injuriesLimited investigationFinal reportContinental Copters Tomcat MK5A · Duson, LAFailure of the transmission mast bearing, resulting in oil contamination and subsequent blockage of the internal oil ports and passages. Factors were: total loss of collective control and partial loss of cyclic control.NTSB CHI93LA300Accident · Minor injuriesLimited investigationFinal reportChampion 7FC · Ortonville, MNthe pilot's failure to refuel prior to fuel exhaustion.NTSB CHI93LA299Accident · No injuriesLimited investigationFinal reportCessna 170B · Steele, NDThe pilot-in-command's poor in-flight decision and failure to maintain proper clearance.NTSB CHI93FA302Accident · 5 fatalField investigationFinal reportRockwell 690-A · Norfolk, NEThe failure of the pilots of the Rockwell 690-A, N707BP, and the Piper PA-28R, N33056, to see and avoid each other. A factor which contributed to the accident was the failure of both pilot's to follow recommended communication procedures contained in the…