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 MIA00FA090Accident · 1 fatalField investigationFinal reportBeech 35-P35 · Dayton, TNthe non-instrumented rated pilot elected to takeoff into known adverse weather conditions, which resulted in impact with rising terrain. Factors in this accident were, clouds and low ceilings.NTSB IAD00LA022Accident · No injuriesLimited investigationFinal reportCessna 172 · Norridgewock, MEthe student pilot's loss of directional control during the takeoff roll.NTSB FTW00LA081Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · College Station, TXThe loss of engine power due to fuel system contamination. A factor was the lack of suitable terrain for the forced landing.NTSB NYC00LA077Accident · No injuriesLimited investigationFinal reportCessna 185 · Saratoga Sprngs, NYThe pilot's loss of control of the airplane during the landing.NTSB NYC00IA078Incident · Minor injuriesIncident investigationFinal reportSaab-Scania 340B · Boston, MAThe vehicle driver's inadequate visual lookout.NTSB LAX00FA097Accident · No injuriesField investigationFinal reportBoeing 757-232 · San Salvador, El SalvadorThe pilot's improper flare which resulted in a bounced landing.NTSB DEN00LA051Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Reserve, NMThe pilot's failure to adequately compensate for wind conditions. A factor was the wind gust.NTSB DCA00WA025Accident · No injuriesForeign investigationBoeing B 727-100 · Luanda, AngolaNTSB CHI00LA069Accident · No injuriesLimited investigationFinal reportBeech A36 · Olathe, KSthe pilots improper use of powerplant controls. A factor in the accident was the plowed farm field.NTSB ATL00LA025Accident · No injuriesLimited investigationFinal reportCessna 152 · Clearwater, FLThe pilot's failure to maintain visual lookout during flight operations under Visual Flight Rules. A factor is that the pilot was not on the airport radio frequency.NTSB IAD00WA020Accident · No injuriesForeign investigationSikorsky CH-3E · Wairoa Gorge, New ZealandNTSB IAD00LA021Accident · 2 fatalLimited investigationFinal reportWood Seawind 3000 · Cumberland Gap, VAThe pilot's continued flight from visual flight rules into instrument meteorological conditions.NTSB DEN00GA050Accident · 2 fatalFinal reportBell OH-58A+ · Woods Cross, UTThe pilot's failure to roll throttle back on (return the power to the normal operating range) during an attempted power recovery from an autorotation, and his subsequent failure to maintain aircraft control.NTSB CHI00FA070Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-60 · Lewiston, IDthe pilot failed to follow the flight manual procedures and did not engage the Continuous Ignition system resulting in both engines flaming out when the air induction system was blocked with ice. Additional factors to the accident included the hilly terrain,…NTSB MIA00LA089Accident · No injuriesLimited investigationFinal reportBeech 76 · Salisbury, NCThe flight instructors inadequate supervision of a dual student who attempted a go around using one engine which resulted in loss of control and impact with the ground.NTSB CHI00LA067Accident · No injuriesLimited investigationFinal reportBeech V35 · Schaumburg, ILinadequate aircraft preflight by the pilot and fuel consumption calculations not being preformed by the pilot. Factors to the accident were fuel exhaustion, the rocks/boulders, and the high vegetation.NTSB ATL00FA024Accident · 2 fatalField investigationFinal reportMooney M20J · Odessa, FLThe pilot's failure to maintain a safe altitude and his failure to attain the proper touchdown point during landing. A factor was the utility pole.NTSB NYC00IA076Incident · No injuriesIncident investigationFinal reportCessna 182P · Hartford, CTThe pilot's failure to maintain a visual lookout.NTSB MIA00LA091Accident · No injuriesLimited investigationFinal reportBeech F90 · Monroe, GAchafed wiring that resulted in an electrical short which initiated the landing gear retraction cycle when cabin heat was activated, resulting in the main landing gear retracting during taxi.NTSB IAD00LA019Accident · No injuriesLimited investigationFinal reportCessna 172 · Lyndonville, VTthe student pilot's failure to maintain directional control during landing. A factor in the accident was the ditch that ran parallel to the runway.NTSB ANC00LA027Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-T3 · Wales, AKThe pilot's inadequate evaluation of the weather conditions, and his inadvertent flight into adverse weather conditions. Factors in the accident were terrain induced turbulence and a tailwind.NTSB NYC00WA216Accident · No injuriesForeign investigationBeech BE-60 · Halle-Oppin, GermanyNTSB MIA00LA087Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Englewood, FLThe failure of the pilot to retract the flaps from the fully extended position following the last landing resulting in the failure to maintain airspeed and subsequent descent for a forced landing. A contributing factor in the accident was the pilot's…NTSB LAX00LA095Accident · Minor injuriesLimited investigationFinal reportCessna 210E · Glendale, AZthe pilot's attempt to go-around with inadequate altitude and airspeed available, resulting in a power demand that exceeded the capability of the aircraft. The fully extended gear and flaps were factors in this accident.NTSB FTW00FA080Accident · 1 fatalField investigationFinal reportBeech B23 · New Braunfels, TXthe seizure of the engine while maneuvering due to the oil pressure relief valve plug ball seat becoming contaminated with metal. Contributing factors were the inadequate engine maintenance, and the lack of suitable terrain for the forced landing.NTSB CHI00MA066Accident · 3 fatalMajor investigationFinal reportMoravan Z242L · Zion, ILClearance not maintained by the pilot of the other airplane. A factor relating to the accident was the airport control tower's local controller's failure to provide effective sequencing.NTSB CHI00LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Alma, MIthe pilot's inadequate fuel consumption calculation. Factors were the rough terrain, the fence and the exhaustion of the fuel supply.NTSB ANC00LA026Accident · No injuriesLimited investigationFinal reportCessna 180 · Glennallen, AKThe pilot's selection of an unsuitable landing site on a frozen, snow-covered lake. A factor associated with the accident was an area of drifted snow at the landing site.NTSB SEA00LA043Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Kahlotus, WAThe pilot's failure to maintain sufficient altitude over, or clearance with, a barbed-wire fence. A factor was the fence.NTSB NYC00LA074Accident · No injuriesLimited investigationFinal reportGrumman American AA1 · Wildwood, NJThe student pilot's failure to maintain directional control. A factor in this accident was the crosswind condition.NTSB MIA00LA086Accident · No injuriesLimited investigationFinal reportCessna 172R · Olive Branch, MSThe student pilot's failure to maintain directional control during landing and the subsequent collision with a taxiway sign and collapsed right main landing gear.NTSB MIA00LA085Accident · No injuriesLimited investigationFinal reportCessna 152 · Louisburg, NCThe improper recovery from the bounced landing by the pilot-in-command for his failure to apply power and inadvertent stall by the pilot-in-command resulting in a hard landing. A contributing factor was the total lack of experience of the pilot-in-command.NTSB LAX00LA253Accident · No injuriesLimited investigationFinal reportCessna 310L · Flagstaff, AZthe fracture across the eyelet of the nose gear retraction rod, which prevented the extension of the nose gear.NTSB LAX00LA096Accident · No injuriesLimited investigationFinal reportCessna 172N · Bermuda Dunes, CAFailure of the student pilot to maintain directional control of the airplane during takeoff.NTSB LAX00FA093Accident · 4 fatalField investigationFinal reportGray Questair Venture · Sylmar, CAThe pilots' inadequate visual lookout in visual conditions and class 'E' airspace. Contributing to the accident were the initial position report location and the approach speed of the Questair.NTSB LAX00FA090Accident · 1 fatalField investigationFinal reportCessna 150J · Redwood City, CAThe pilot's inadequate weather evaluation and continued visual flight into instrument meteorological conditions. Factors were the pilot's improper remedial action and his self-induced pressure.NTSB DEN00TA049Accident · Minor injuriesFinal reportCessna A185F · Loveland, COFailure of the pilot in command to maintain directional control, resulting in an inadvertent ground loop. A factor was the crosswind.NTSB ANC00LA025Accident · No injuriesLimited investigationFinal reportCessna 207 · Tuluksak, AKThe pilot's failure to maintain proper alignment during the takeoff roll. A factor associated with the accident was a soft area of snow on the runway.NTSB NYC00LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Vincentown, NJThe CFI's delay in remedial action after the student pilot lost control of the airplane. A factor in the accident was the CFI's lack of total experience in flight instruction.NTSB MIA00GA083Accident · Serious injuriesFinal reportRockwell OV-10D · Larandia, ColombiaA loss of power in the right engine due to undetermined reasons and the pilot's failure to maintain control of the airplane. Factors in this accident were; the pilot did not perform a weight and balance calculation, (airplane overweight at takeoff); the…NTSB LAX00LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Honolulu, HIThe pilot's improper use of the brakes during the landing rollout. The pilot's self induced pressure and the quartering tailwind were factors in the accident.NTSB LAX00LA092Accident · No injuriesLimited investigationFinal reportLutes Kitfox II · Livermore, CAThe pilot's inadequate compensation for the existing crosswind condition and his failure to maintain runway alignment.NTSB NYC00LA072Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Alton Bay, NHThe pilot's failure to maintain control of the airplane during takeoff which resulted in an inadvertent stall. A factor in the accident was the pilot's inadequate compensation for the wind conditions.NTSB MIA00WA084Accident · 1 fatalForeign investigationMcDonnell Douglas 369E · Grand Turk, Turks & Caicos IslandsNTSB LAX00LA091Accident · Serious injuriesLimited investigationFinal reportIzatt Mitchell U2 · Jean, NVThe pilot's failure to maintain an adequate airspeed, which resulted in an inadvertent stall and spin.NTSB DEN00LA048Accident · Serious injuriesLimited investigationFinal reportBeech M35 · Albuquerque, NMThe pilot inadvertently allowing the airplane to stall. Factors were the missing alternator belt and the resultant total electrical system failure, and the pilot's attention being diverted.NTSB CHI00LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Chesterfield, MOThe pilot failed to maintain directional control during the takeoff portion of a touch and go landing.NTSB ANC00FA024Accident · 6 fatalField investigationFinal reportCessna U206G · Iliamna, AKThe pilot's attempted flight into adverse weather, and his failure to maintain altitude/clearance above the snow-covered tundra. Factors associated with the accident were snow, rain, and whiteout conditions.NTSB MIA00LA082Accident · Minor injuriesLimited investigationFinal reportMooney M-20C · Andrews, NCThe pilot's failure to use carburetor heat in a timely manner while maneuvering in conditions conducive to carburetor icing, resulting in the loss of engine power and collision with trees during the subsequent emergency descent.NTSB MIA00LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Fayette, ALThe pilot's failure to maintain directional and altitude control of the airplane during a ago-around maneuver, resulting in collision with a fence and utility pole.