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.

NTSB LAX91LA239Accident · Minor injuriesLimited investigationFinal reportMaule M-4-220C · Byron, CAThe failure of the pilot-in-command to perform an adequate preflight inspection by taking the necessary steps to eliminate water contamination of the airplane's fuel system.Jun 2, 1991 · N40693 · Substantial damageNTSB LAX91LA238Accident · Serious injuriesLimited investigationFinal reportBellanca 7FC · Sedona, AZThe total loss of engine power for undetermined reasons resulting in a forced landing and on ground collision with a berm.Jun 2, 1991 · N8527E · DestroyedNTSB FTW91FA089Accident · 2 fatalField investigationFinal reportSteen Skybolt JW5 · Grand Prairie, TXThe pilot's failure to perform refueling and maintain airspeed above vs (stall). A factor was unsuitable terrain.Jun 2, 1991 · N124J · DestroyedNTSB BFO91FA053Accident · Serious injuriesField investigationFinal reportBeech B65 · California, MDThe loss of power in one engine for undetermined reasons.Jun 2, 1991 · N655KJ · DestroyedNTSB NYC91LA153Accident · No injuriesLimited investigationFinal reportCessna 310R · Westerly, RIImproper installation of the right propeller which resulted in thread failure in the propeller hub and separation of the propeller in flight. A factor related to the accident was the right propeller striking the right main landing gear causing its separation…Jun 1, 1991 · N3227A · Substantial damageNTSB MIA91WA157Accident · 2 fatalForeign investigationGovernment Aircraft Fact N24A · Great Inagua, Turks & Caicos IslandsJun 1, 1991 · N8071L · DestroyedNTSB LAX91LA237Accident · No injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Antioch, CAThat the pilot's preflight was improper; that he departed with the carburetor heat on; failed to abort when it became evident that the airplane was not going to take off; and abruptly lifting the airplane so that it became airborne in ground effect, but then…Jun 1, 1991 · N49173 · Substantial damageNTSB LAX91LA236Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Fort Ord, CAPartial loss of engine power for undetermined reasons.Jun 1, 1991 · N4SH · Substantial damageNTSB LAX91LA235Accident · No injuriesLimited investigationFinal reportBeech B95-B55 · Glendale, AZThe pilot's failure to secure the fuel cap during his preflight inspection. As a result, fuel leaked out of the wing tank onto the wing and ignited during the engine start procedures.Jun 1, 1991 · N14SC · Substantial damageNTSB LAX91LA234Accident · No injuriesLimited investigationFinal reportCessna T-210 · St. Helena, CAThat the pilot executed a poorly planned approach and failed to attain a proper touchdown point and delayed the go-around.Jun 1, 1991 · N3Z · Substantial damageNTSB LAX91LA233Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Point Magu, CAA short circuit in the airplane's strobe light electrical system which ignited the plastic tubing of the pitot static system causing an inflight fire and subsequent forced landing.Jun 1, 1991 · N9663B · Substantial damageNTSB LAX91FA232Accident · 2 fatalField investigationFinal reportPiper PA-23 · Maricopa, AZThe pilot's poor judgement in the operation of the airplane with known deficiencies and the inadvertent stall during a forced landing. The pilot/owners lack of maintenance on the airplane and the pilot's impairment by alcohol were factors in the accident.Jun 1, 1991 · N1237P · DestroyedNTSB FTW91FA088Accident · 4 fatalField investigationFinal reportBeech A36 · Lakeview, ARThe pilot's improper visual approach, and his failure to maintain an adequate visual lookout for obstructions. Factors were the unmarked power linesJun 1, 1991 · N324CB · DestroyedNTSB FTW91DPG12Accident · Minor injuriesFinal reportBell 47-G3B1 · Colt, ARLoss of engine power for an undetermined reason. A factor was the unsuitable terrain.Jun 1, 1991 · N31052 · DestroyedNTSB CHI91LA179Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Battle Creek, MIAircraft control by the dual student was not maintained, remedial action by the CFI was delayed, which resulted in a stall/mush. A factor related to the accident was rough water caused by a power boat wake.Jun 1, 1991 · N2596P · Substantial damageNTSB CHI91DTG01Accident · 1 fatalFinal reportCessna 172P · Bismarck, NDSpatial disorientation. Factors related to the accident are failure to obtain a preflight weather brief, vrf flight into IMC conditions and lack of total experience.Jun 1, 1991 · N5478K · DestroyedNTSB CHI91DEE05Accident · Minor injuriesFinal reportCharles Raucci, JR. Firebolt · Schaumburg, ILThe pilot not following the specification for installation of the fuel tank vent.Jun 1, 1991 · N123CR · Substantial damageNTSB CHI91DCA01Accident · Serious injuriesFinal reportGremminger Kolb Twinstar · St. Genevieve, MOThe failure of the pilot to abort the takeoff and improper remedial action by the pilot rated passenger after assuming control of the airplane. A factor associated with the accident is the pilot losing directional control during the takeoff ground run.Jun 1, 1991 · N7175J · Substantial damageNTSB BFO91LA052Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Elkins, WVThe loss of engine power for undetermined reasons.Jun 1, 1991 · N6904B · Substantial damageNTSB ATL91LA104Accident · Serious injuriesLimited investigationFinal reportPeecher EAA Biplane P-2 · Dalton, GAThe pilot's failure to maintain airspeed when he diverted his attention outside the airplane which resulted in an inadvertent stall and subsequent collision with trees.Jun 1, 1991 · N202P · DestroyedNTSB NYC91FA145Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Wallingford, CTThe pilot attempting a VFR flight in adverse weather conditions, at an altitude that was insufficient to clear trees along his route of flight. Factors related to the accident were the pilot's lack of instrument rating, and his overconfidence to fly in…May 31, 1991 · N36069 · DestroyedNTSB MIA91LA156Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Quincy, FLThe pilot's inadequate preflight inspection and the blocked vent line.May 31, 1991 · N9646S · Substantial damageNTSB MIA91FA155Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Long Boat Key, FLAn inflight loss of control and subsequent collision with the water for unknown reasons.May 31, 1991 · N6376P · DestroyedNTSB LAX91LA230Accident · No injuriesLimited investigationFinal reportCessna P210N · Palm Springs, CAFailure of the pilot to maintain directional control during the landing roll.May 31, 1991 · N818BF · Substantial damageNTSB CHI91LA178Accident · No injuriesLimited investigationFinal reportCessna 172E · Grundy Center, IAFailure by other maintenance personnel to install a safety wire and fuel exhaustion.May 31, 1991 · N3663S · Substantial damageNTSB CHI91LA177Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Depere, WIThe pilot's failure to correct a mushed stall during liftoff. A factor in the accident was the pilot's failure to compensate for wind conditions.May 31, 1991 · N4090N · DestroyedNTSB CHI91LA176Accident · No injuriesLimited investigationFinal reportCessna 152 II · Holland, MIThe pilot's failure to maintain control of the airplane during the touchdown and landing roll on a sod runway. Factors in the accident are the uneven terrain at the runway intersection, and the pilot's improper recovery from a bounced landing.May 31, 1991 · N714UH · Substantial damageNTSB ATL91LA105Accident · No injuriesLimited investigationFinal reportCessna 188 · Sycamore, SCThe pilot's failure to secure the gust lock during prelflight; the string jammed the flight controls and created an uncontrollable condition.May 31, 1991 · N731EP · Substantial damageNTSB FTW91LA087Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Horseshoe Bend, ARThe pilot's failure to maintain directional control of the airlane. A factor was the crosswind.May 30, 1991 · N4561N · Substantial damageNTSB CHI91TL#04Accident · Minor injuriesClass 3Final reportHughes TH-55A · Roseau, MNMay 30, 1991 · N115NR · Substantial damageNTSB CHI91DEV01Accident · No injuriesFinal reportCessna A188B · Bluffs, ILThe pilot's failure to maintain directional control.May 30, 1991 · N4887Q · Substantial damageNTSB ATL91LA103Accident · No injuriesLimited investigationFinal reportCessna 150F · Monroe, NCThe pilot's selection of unsuitable terrain for takeoff. The unmowed grass runnway was a related factor.May 30, 1991 · N8026S · Substantial damageNTSB LAX91LA228Accident · No injuriesLimited investigationFinal reportBeech C-45H · Lake Elsinore, CAFuel starvation due to an improper modification of the fuel system and the pilot's failure to ensure that the aircraft was airworthy prior to flight.May 29, 1991 · N9903Z · Substantial damageNTSB CHI91IA175Incident · Minor injuriesIncident investigationFinal reportDouglas DC-9-32 · Kansas City, MOInadequate design by the manufacturers. Factors associated with the incident are inadequate certification/approval by the federal aviation administration and clear air turbulence.May 29, 1991 · N933ML · No damageNTSB ATL91LA102Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Lake Seminole, GAThe failure of the pilot to maintain clearance from the surface.May 29, 1991 · N9650N · DestroyedNTSB SEA91FA124Accident · No injuriesField investigationFinal reportBell 206BII · Brewster, WAThe pilot-in-command's selection of unsuitable terrain for the emergency simulation.May 28, 1991 · N90307 · Substantial damageNTSB NYC91LA143Accident · No injuriesLimited investigationFinal reportCessna 120 · Wellsville, PAA power loss due to a fuel system blockage which resulted in a forced landing.May 28, 1991 · N2714N · Substantial damageNTSB LAX91T#A09Accident · Serious injuriesClass 3Final reportHughes 369 · Hilo, HIMay 28, 1991 · N8386F · DestroyedNTSB LAX91LA244Accident · No injuriesLimited investigationFinal reportCessna 172M · Willits, CAThat the pilot misjudged the flare and failed to properly recover from a bounced landing. Contributing to this accident was entering into an inadvertent porpoise.May 28, 1991 · N1407U · Substantial damageNTSB CHI91LA173Accident · Serious injuriesLimited investigationFinal reportGulfstream American AA1A · Evansville, INThe failure by maintenance personnel to identify the proper replacement cylinder.May 28, 1991 · N5675L · Substantial damageNTSB CHI91LA171Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Hillsdale, MIFailure of the pilot to maintain directional control during the takeoff ground run. A factor associated with the accident is the pilot's lack total experience.May 28, 1991 · N5299B · Substantial damageNTSB CHI91LA170Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Albany, MNThe cfi's failure to take timely and proper remedial action when the student pilot lost directional control during the takeoff roll. Factors in the accident are the tall grass edging the runway, and the student pilot's lack of total experience.May 28, 1991 · N95041 · Substantial damageNTSB CHI91LA169Accident · No injuriesLimited investigationFinal reportCessna 172M · Cadillac, MIThe pilot-in-command's maintaining excessive airspeed through the landing touchdown which resulted in overrunning the runway.May 28, 1991 · N9591V · Substantial damageNTSB CHI91LA168Accident · No injuriesLimited investigationFinal reportCessna 150 · Cambridge, MNPartial loss of engine power due to improper use of carburetor heat and a stall encountered by the pilot.May 28, 1991 · N8845S · Substantial damageNTSB CHI91LA167Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Cottage Grove, MNThe pilot in command's improper pre flight planning and preparation. Factors contributing to this accident were the pilot in command's lack of familiarity with the airplane and improper fuel consumption calculations.May 28, 1991 · N5172M · Substantial damageNTSB ATL91LA101Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Little River, SCThat the pilot dragged the right wing tip on final approach when he failed to control the aircraft. Factors to this accident were: a wind shift below the treetops.May 28, 1991 · N1181S · Substantial damageNTSB SEA91LA136Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Wilson Creek, WAThe loss of engine power in flight due to improper overhaul of the carburetor float assembly fulcrum screw, shutting off fuel flow to the engine.May 27, 1991 · N8407K · Substantial damageNTSB SEA91LA127Accident · Serious injuriesLimited investigationFinal reportMaxair Ultralight · Toledo, WAThe pilot's inattentiveness. Factors were his performance of a low pass, and a transmission wire in his flight path.May 27, 1991 · UNREG · Substantial damageNTSB SEA91LA117Accident · Minor injuriesLimited investigationFinal reportCessna T-210N · Klamath Falls, ORThe loss of engine power due to failure of the number 5 cylinder rod bearing which resulted from lack of lubrication of the main bearing.May 27, 1991 · N5375A · Substantial damageNTSB SEA91LA116Accident · Serious injuriesLimited investigationFinal reportGreg Smith KR-2 · Twisp, WAThe loss of engine power in flight due to shorted magneto wires, resulting from inadequate maintenance inspection by the pilot.May 27, 1991 · N47KR · Substantial damage