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 LAX99LA191Accident · No injuriesLimited investigationFinal reportMaule M-4-210C · Lancaster, CAThe pilot's failure to maintain directional control during the landing rollout. A factor in the accident was the pilot's limited experience in conventional gear airplanes.May 22, 1999 · N51450 · Substantial damageNTSB LAX99LA189Accident · Serious injuriesLimited investigationFinal reportCameron A-250 · Windsor, CAThe pilot did not obtain the most current weather briefing available, which forecast high winds about his actual landing time. The balloon encountered high winds and collided with an embankment in a field during a precautionary hard landing. Factors in the…May 22, 1999 · N3037V · Substantial damageNTSB LAX99LA188Accident · Minor injuriesLimited investigationFinal reportCessna 414 · Orland, CAA loss of engine power in both engines due to fuel contamination, which resulted from the fueling facilities improper quality control procedures.May 22, 1999 · N8153Q · Substantial damageNTSB IAD99LA044Accident · Serious injuriesLimited investigationFinal reportMayers SEA REY · Ashland, VAwas a loss of engine power for undetermined reasons.May 22, 1999 · N100RZ · DestroyedNTSB FTW99LA144Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Slidell, LAThe student pilot's delayed landing flare and her subsequent improper recovery technique following the bounced landing.May 22, 1999 · N4850B · Substantial damageNTSB FTW99FA143Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Rose Bud, ARThe pilot's failure to maintain minimum required airspeed for flight, which resulted in an inadvertent stall.May 22, 1999 · N95754 · Substantial damageNTSB DEN99LA084Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Baggs, WYThe pilot not maintaining the main rotor's RPM. Factor's were the high density altitude, and the mountainous/hilly terrain.May 22, 1999 · N535H · Substantial damageNTSB ATL99LA093Accident · No injuriesLimited investigationFinal reportRobert W. Ferrell Titan Tornado II · Ashboro, NCThe loss of engine power for undetermined reasons. Factors were weather conditions favorable for the formation of carburetor ice.May 22, 1999 · N624RF · Substantial damageNTSB ATL99LA092Accident · Minor injuriesLimited investigationFinal reportMurray R. Gardner FLY Baby · Mount Olive, NCA fatigue failure of the flywire bracket that resulted in the inflight separation of the left wing.May 22, 1999 · N96MG · Substantial damageNTSB SEA99LA076Accident · No injuriesLimited investigationFinal reportCessna A185E · Othello, WAThe pilot's inadequate compensation for wind conditions after landing. Factors include gusty winds.May 21, 1999 · N50AU · Substantial damageNTSB SEA99LA072Accident · No injuriesLimited investigationFinal reportCessna R172K · Aurora, ORAircraft control was not maintained. The pilot's misjudged flare and inadequate remedial action, along with the flight instructors delayed remedial action were factors.May 21, 1999 · N1909V · Substantial damageNTSB SEA99LA068Accident · No injuriesLimited investigationFinal reportCessna 182N · Granite, ORClearance was not maintained. A sign and the selection of unsuitable terrain for landing were factors.May 21, 1999 · N92887 · Substantial damageNTSB NYC99LA117Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Leesburg, VAThe pilot-in-command's (CFI) failure to maintain control of the airplane.May 21, 1999 · N78659 · Substantial damageNTSB NYC99LA114Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Columbus, OHthe failure of the pilot to follow the procedures in the Pilot's Operating Handbook, and the use of tip tanks for level flight only, which resulted in fuel starvation. A factor was the pilot's lack of familiarity with the airplane.May 21, 1999 · N7355R · Substantial damageNTSB LAX99LA195Accident · No injuriesLimited investigationFinal reportBeech A36 · Willows, CAThe failure of the pilot to maintain an adequate clearance with a parked trailer while taxiing the aircraft.May 21, 1999 · N8178N · Substantial damageNTSB FTW99LA147Accident · No injuriesLimited investigationFinal reportCessna TU206C · West, TXThe pilot's improper recovery from a bounced landing.May 21, 1999 · N29096 · Substantial damageNTSB FTW99LA146Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Palacios, TXThe pilot's failure to maintain clearance with terrain. A factor was the high vegetation.May 21, 1999 · N9670P · Substantial damageNTSB FTW99LA145Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Lufkin, TXThe loss of control due to the separation of the left main landing gear as a result of the fatigue failure of the U-bolt which attaches the landing gear to the airframe.May 21, 1999 · N5500C · Substantial damageNTSB DEN99LA082Accident · No injuriesLimited investigationFinal reportRich RV3-A · Bountiful, UTThe pilot's inadequate preflight planning, and the subsequent fuel exhaustion during the flight. Factor was the airplane's inaccurate fuel gauge.May 21, 1999 · N4461V · Substantial damageNTSB DEN99LA079Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Richfield, UTThe pilot's failure to maintain adequate altitude/clearance from the wires while maneuvering during an aerial application.May 21, 1999 · N8531L · DestroyedNTSB CHI99LA157Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · East Troy, WIThe pilot's improper approach to landing A factor associated with the accident was the pilot's inadvertent settling with power.May 21, 1999 · N215WW · Substantial damageNTSB ATL99LA096Accident · No injuriesLimited investigationFinal reportRutan VERI-EZE · Enterprise, ALThe pilot's failure to remove covers from the fuel tank vent which resulted in fuel starvation.May 21, 1999 · N80SH · Substantial damageNTSB ATL99LA095Accident · No injuriesLimited investigationFinal reportAircraft Parts & Dev. A-9B · Hartsell, ALThe pilot's failure to maintain flying speed that resulted in the inflight collision with the ground. A factor was the pilot's lack of total experience in the aircraft.May 21, 1999 · N9082A · Substantial damageNTSB SEA99LA175Accident · No injuriesLimited investigationFinal reportCessna 150M · Buhl, IDAn inadequate recovery from a bounced landing. Gusting wind conditions were a factor.May 20, 1999 · N3834V · Substantial damageNTSB NYC99LA115Accident · Serious injuriesLimited investigationFinal reportHammond Twinstar Gyroplane · Bloomsburg, PAThe pilot's failure to maintain sufficient takeoff rpm. Factors included crosswind gusts, and the FAA's lack of category and class rating requirements for pilots flying non-type-certificated experimental aircraft.May 20, 1999 · N6364H · Substantial damageNTSB MIA99FA159Accident · 1 fatalField investigationFinal reportClassic S-51D · Tamarac, FLA complete loss of engine power caused by the malfunctioning landing gear, which blocked the radiator scoop, leading to increased fuel temperature and the subsequent vapor lock condition and fuel blockage. A secondary cause was the pilot's failure to maintain…May 20, 1999 · N25VV · DestroyedNTSB MIA99FA158Accident · 1 fatalField investigationFinal reportHughes 369E · Intercession, FLThe pilot's improper fuel management that resulted in fuel exhaustion and a total loss of engine power.May 20, 1999 · N144CM · Substantial damageNTSB LAX99LA187Accident · No injuriesLimited investigationFinal reportCessna 150J · Alderpoint, CAThe pilot's inadequate compensation for the existing turbulent, gusty wind conditions during the approach. Contributing factors were the pilot's delayed go-around maneuver, the gusty and turbulent winds, and the tree.May 20, 1999 · N51096 · Substantial damageNTSB FTW99LA135Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Taylor, TXThe pilot's failure to maintain a proper glide path, which resulted in a collision with a wire. A factor was the dark night condition.May 20, 1999 · N6558C · Substantial damageNTSB DEN99LA090Accident · No injuriesLimited investigationFinal reportBeech D95A · Englewood, COThe collapse of the right main landing gear during landing due to a fatigue crack, in the strut, which had an undetermined origin.May 20, 1999 · N64TA · Substantial damageNTSB DEN99LA080Accident · No injuriesLimited investigationFinal reportArtic S-1B2 · Lamar, COThe pilot's failure to maintain directional control during initial climb following takeoff. A factor was the pilot's lack of experience in the type of aircraft, and the fence.May 20, 1999 · N70AT · Substantial damageNTSB ATL99LA094Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Millington, TNLoss of engine power due to undetermined reasons. Factors were weather conditions favorable to carburetor ice and the terrain condition at the forced landing site.May 20, 1999 · N5363T · Substantial damageNTSB SEA99LA067Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Okanogan, WAA malfunctioning carburetor. Factors include a downdraft, and the soft dirt in a newly plowed field.May 19, 1999 · N6861K · Substantial damageNTSB SEA99LA066Accident · No injuriesLimited investigationFinal reportMooney M-20G · Burlington, WAA loss of engine power due to carburetor contamination. Factors include the pilot's misjudgment of altitude and distance when he performed his forced landing.May 19, 1999 · N6700N · Substantial damageNTSB MIA99LA157Accident · Serious injuriesLimited investigationFinal reportCessna A-188B · Anguilla, MSThe pilot's inadequate management of the fuel supply which led to fuel exhaustion and subsequent loss of engine power.May 19, 1999 · N9212R · DestroyedNTSB MIA99LA156Accident · 2 fatalLimited investigationFinal reportChampion Glastar · Mableton, GAAn in-flight loss of control for undetermined reasons, resulting in an in-flight collision with trees and the ground.May 19, 1999 · N75419 · DestroyedNTSB LAX99LA186Accident · Minor injuriesLimited investigationFinal reportRobinson R22A · San Luis Obispo, CAThe student's inadvertent and uncoordinated application of forward cyclic during an autorotation flare, which resulted in a loss of main rotor rpm; and the flight instructor's inadequate supervision.May 19, 1999 · N8558N · Substantial damageNTSB DEN99FA081Accident · 2 fatalField investigationFinal reportPiper PA-23E-250 · Tucumcari, NMThe pilot's inadvertent stall. A factor was the loss of power of one engine in the twin-engine airplane.May 19, 1999 · N54263 · DestroyedNTSB ANC99LA063Accident · No injuriesLimited investigationFinal reportTaylorcraft F-19 · Anchorage, AKThe pilot misjudging the taxi clearance between the airplane's wingtip and the parked vehicle.May 19, 1999 · N3585T · Substantial damageNTSB LAX99LA185Accident · No injuriesLimited investigationFinal reportCessna 172R · Imperial, CAThe pilot's misjudged landing flare, which led to an inadvertent porpoise condition.May 18, 1999 · N9897F · Substantial damageNTSB CHI99LA168Accident · No injuriesLimited investigationFinal reportCessna 172P · Wichita, KSthe student pilot's improper recovery from a bounced landing.May 18, 1999 · N172YA · Substantial damageNTSB FTW00RA093Accident · Serious injuriesForeign investigationBell 206L4 · Cuenca, EcuadorMay 17, 1999 · HCBYQNTSB CHI99LA156Accident · No injuriesLimited investigationFinal reportBeech 99A · Bemidji, MNFailure of the left main landing gear actuator for undetermined reasons.May 17, 1999 · N133BA · Substantial damageNTSB CHI99GA155Accident · 2 fatalFinal reportBell OH-58A · Poplar Bluff, MOThe tail rotor's impact with the blue warm-up jacket and the subsequent overload of the tail rotor drive shaft. A contributing factor was the absence of the helicopter's entry doors.May 17, 1999 · N77MP · DestroyedNTSB SEA99LA062Accident · No injuriesLimited investigationFinal reportCessna 172M · Omak, WAThe pilot's failure to properly secure the aircraft before hand-propping.May 16, 1999 · N73040 · Substantial damageNTSB NYC99LA113Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Grafton, OHInadequate maintenance which resulted in the failure of the mercury clutch assembly.May 16, 1999 · N812WC · Substantial damageNTSB NYC99LA112Accident · Serious injuriesLimited investigationFinal reportAbrams Titan Tornado · Monroe, CTThe failure of the magneto (mag) cylinder bearing resulting in a total loss of power and subsequent forced landing.May 16, 1999 · N194PA · Substantial damageNTSB IAD99LA042Accident · No injuriesLimited investigationFinal reportCessna 182K · Baltimore, MDwas the pilot's improper remedial action when he improperly used the elevator during the landing flare.May 16, 1999 · N2506Q · Substantial damageNTSB CHI99LA154Accident · No injuriesLimited investigationFinal reportCessna R182 · Chesterfield, MOthe pilot's failure to attain clearance over the fence. Factors associated with the accident were the pilot's inadequate compensation for the wind conditions which resulted in a loss of directional control, the crosswind, and the fence posts.May 16, 1999 · N738WK · Substantial damageNTSB CHI99LA153Accident · No injuriesLimited investigationFinal reportBell 222UT · Rockton, ILThe pilot's misjudged flare during landing. A factor to the accident was the dark night lighting condition.May 16, 1999 · N781SA · Substantial damage