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 CHI96LA149Accident · 1 fatalLimited investigationFinal reportDeweese Bushby Mustang M-II · Lancaster, WIfailure of the pilot to maintain adequate airspeed, while maneuvering in the traffic pattern, which resulted in an inadvertent stall/spin and collison with the terrain. The pilot's use of abrupt maneuvers was a related factor.NTSB ANC96LA066Accident · No injuriesLimited investigationFinal reportSwearingen SW-4 · St George, AKfailure of the captain to maintain proper altitude and wingtip clearance, while aligning the airplane with the runway before landing. His delay in aligning the aircraft with the runway was a related factor.NTSB SEA96LA087Accident · No injuriesLimited investigationFinal reportNanchang CJ-6A · Molalla, ORthe pilot's failure to adequately plan the approach, and his misjudgment of distance and speed during the landing. The wet runway was a related factor.NTSB NYC96LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Chester, NHThe pilot's misjudged distance and altitude during final approach.NTSB IAD96LA070Accident · Serious injuriesLimited investigationFinal reportBellanca BL17-31ATC · Wauseon, OHthe pilot's failure to maintain control of the aircraft which resulted in an inadvertent stall while on short final approach to land.NTSB FTW96LA201Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-233A · Odessa, TXthe pilot's failure to obtain the required airspeed resulting in a hard landing. A factor was the lack of thermal lift.NTSB CHI96LA153Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Layfayette, INthe pilot's improper flare and improper recovery from a bounced landing.NTSB ANC96LA068Accident · No injuriesLimited investigationFinal reportCessna 185 · Kodiak, AKthe pilot's inadequate compensation for the crosswind conditions. Factors associated with the accident were the soft terrain at the landing site, and a crosswind.NTSB MIA96LA136Accident · No injuriesLimited investigationFinal reportBeech UC45J · Opa Locka, FLinadequate inspection of the fuel line connector by company maintenance personnel, and failure of a connector resulting in a fuel leak and fire.NTSB LAX96TA187Accident · Minor injuriesFinal reportHughes 369 · Yuma, AZfailure of the pilot to maintain control of the helicopter, while maneuvering close to the ground. The unfavorable wind condition was a related factor.NTSB FTW96TA195Accident · No injuriesFinal reportRockwell NA-265-80 · Albuquerque, NMoverdeflection of the left outboard main landing gear tire, probably due to underinflation and inadequate inspection, which resulted in fatigue failure of the left outboard tire and subsequent failure of the left inboard tire.NTSB FTW96LA197Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Peyton, COthe failure of the right main tire due to valve stem separation.NTSB FTW96FA198Accident · No injuriesField investigationFinal reportBeech 1900D · Denver, COfatigue failure of the right main landing gear hydraulic actuator rod at the spherical bearing due to a lack of lubrication.NTSB CHI96LA148Accident · No injuriesLimited investigationFinal reportFairchild M-62C · Garden City, KSfailure of the left main landing gear strut due to corrosoion.NTSB CHI96LA147Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Blaine, MNfailure of the pilot to maintain adequate airspeed while circling at low altitude, which resulted in an inadvertent stall/spin.NTSB ATL96FAMS1Accident · 3 fatalMissing aircraftFinal reportAero Commander 500-B · MissingUndetermined.NTSB ANC96LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Fairbanks, AKThe student pilot's premature flare and the flight instructor's failure to perform remedial action prior to the hard landing.NTSB ANC96LA064Accident · No injuriesLimited investigationFinal reportAviat A-1 · Togiak, AKThe pilot's failure to remove frost from the surface of the wings and his delay in aborting the takeoff. Factors in the accident were the presence of frost on the wings and a deteriorated climb performance.NTSB ANC96LA063Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Dillingham, AKfailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground loop/swerve.NTSB ANC96IA065Incident · No injuriesIncident investigationFinal reportVeazie Super Acro Zenith CH · Fairbanks, AKthe pilot's improper understanding of his amended clearance, and the local controller's failure to assure that the pilot understood that he was cleared only to land. Factors in the incident were: the airport design that places two airplanes in close proximity…NTSB NYC96LA095Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-R200 · Forks Township, PAthe flight instructor's misjudgment of distance and altitude, and delay in performing remedial action.NTSB LAX96TA186Accident · No injuriesFinal reportHughes 369 · Yuma, AZfailure of the pilot to maintain altitude and/or clearance from obstacles, while maneuvering a low altitude at night. Factors relating to the accident were: darkness and the lack of visual cues.NTSB LAX96FA185Accident · Serious injuriesField investigationFinal reportRobinson R22 · Santa Ana, CAthe pilot misjudged the helicopter's distance and altitude and failed to attain the proper descent rate.NTSB FTW96LA199Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Mountain Home, ARthe pilot's failure to visually check the fuel quantity during the preflight inspection. A factor was the unsuitable terrain for the forced landing.NTSB FTW96LA194Accident · No injuriesLimited investigationFinal reportChampion 7AC · Pine Bluff, ARthe pilot's failure to follow proper starting procedures, and an inadequate tie-down.NTSB ATL96LA083Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Cochran, GAfailure of the flight instructor (CFI) to maintain directional control of the airplane during takeoff, when the airplane encountered an uneven area on the airstrip and becoming airborne prematurely; and his failure to maintain clearance (or altitude) from…NTSB ANC96LA067Accident · No injuriesLimited investigationFinal reportCessna 170 · Dillingham, AKrotation (slippage) of the tire on the rim, and shearing of the valve stem, which allowed the rim to contact the ground and then separate.NTSB LAX96IA184Incident · No injuriesIncident investigationFinal reportBoeing 737-300-3H4 · Ontario, CAThe repair facility's improper assembly of the landing gear oleo strut during overhaul.NTSB ANC96LA062Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Togiak, AKfatigue failure of the right main landing gear strut.NTSB NYC96FA094Accident · 2 fatalField investigationFinal reportCessna 172RG · Duanesburg, NYfailure of the pilot to attain adequate airspeed (or abort the takeoff while there was sufficient runway remaining), which resulted in a stall after liftoff and collision with the terrain. A factor relating to the accident was: the pilot's distraction due to…NTSB MIA96FA134Accident · 2 fatalField investigationFinal reportBeech V35 · Powelton, GAthe pilot's continued flight into known adverse weather conditions, resulting in an in-flight separation of the left wing and ruddervator. Factors in this accident were: level three and four thunderstorms, intense to extreme precipitation, and severe…NTSB LAX96LA181Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Riverside, CAthe loss of directional control by the pilot's inadequate compensation for the wind gusts, and improper use of the engine and flight controls. The wind was a factor.NTSB LAX96LA179Accident · No injuriesLimited investigationFinal reportCessna 152 · Chandler, AZthe pilot's misjudged flare, improper bounced landing recovery, and failure to maintain directional control.NTSB CHI96FA146Accident · 3 fatalField investigationFinal reportCessna 421 · Bernard, IAthe pilot's operation of the airplane with known deficiencies, subsequent loss of oil from the left engine, and the pilot's failure to maintain minimum controllable airspeed (VMC), while diverting to an alternate airport. Factors relating to the accident…NTSB SEA96LA085Accident · No injuriesLimited investigationFinal reportAero Commander 200D · Covington, WAfuel starvation, due to the pilot's improper fuel management. The uneven terrain in the forced landing area was a related factor.NTSB NYC96LA093Accident · No injuriesLimited investigationFinal reportCessna 172P · Rutland, VTthe pilot's improper flare and recovery from a bounced landing. A contributing factor was his lack of recent flight experience.NTSB MIA96LA133Accident · No injuriesLimited investigationFinal reportMooney M20C · Cullowhee, NCThe pilot's inadequate compensation for wind conditions. The gusty/crosswind condition was a related factor.NTSB LAX96LA180Accident · No injuriesLimited investigationFinal reportCessna 320 · Mammoth Lakes, CAthe partial failure of the right engine turbocharger wastegate butterfly valve to fully close due to mechanical binding and the low setting of its associated absolute pressure controller. A related factor was the high density altitude which reduced the…NTSB FTW96TA186Accident · No injuriesFinal reportCessna T210N · Beaumont, TXFuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA187Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · Carlsbad, NMThe pilot's inadequate compensation for wind conditions. Factors relating to the accident were: the sudden windshift and/or windshear.NTSB CHI96IA145Incident · Minor injuriesIncident investigationFinal reportBoeing 727-222A · Chicago, ILa passenger disturbance that required the flight attendant to leave her seat. A factor in this accident was the encounter with turbulence as the flight attendant was performing her assigned duties.NTSB ANC96LA061Accident · No injuriesLimited investigationFinal reportCessna 180 · Hope, AKThe pilot's selection of unsuitable terrain for landing. A factor in the accident was soft terrain.NTSB ANC96LA060Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kasilof, AKfuel starvation due to a kinked fuel supply line from the left main tank, and the pilot's improper rebuild/remanufacture of the airplane. A smaller than standard fuel line from the fuel strainer to the carburetor, a smaller than standard fuel cap vent, and a…NTSB ANC96FA059Accident · 1 fatalField investigationFinal reportCessna 150 · Palmer, AKloss of engine power due to a malfunction of the airplane's magneto ignition system, and the pilot's failure to have an annual inspection performed. Factors relating to the accident were: the pilot's lack of recent experience and inadequate in-flight planning…NTSB SEA96LA084Accident · No injuriesLimited investigationFinal reportCessna 152 · Erda, UTfailure of the pilot to maintain directional control of the airplane during the landing. Darkness was a related factor.NTSB MIA96LA135Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-6 · Raeford, NCfailure of the passenger to follow the instructions of ground personnel as she exited the aircraft.NTSB MIA96LA132Accident · Minor injuriesLimited investigationFinal reportAerotek Pitts S-2A · Reidsville, NCthe pilot failed to maintain control of the airplane while performing an acrobatic maneuver.NTSB LAX96LA178Accident · No injuriesLimited investigationFinal reportCessna TR182 · San Diego, CAthe pilot's failure to maintain directional control during landing rollout as a result of his excessive application of brakes and improper use of the elevator (yoke) control.NTSB IAD96LA069Accident · No injuriesLimited investigationFinal reportCessna 172L · Culpeper, VAThe pilot's improper compensation for the crosswind.NTSB IAD96LA068Accident · No injuriesLimited investigationFinal reportBeech B55 · Lynchburg, VAThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop/swerve and landing gear collapse. A related factor was the strong crosswind.