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 FTW99LA238Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob 103C · San Antonio, TXThe pilot's failure to attain proper runway alignment of the glider resulting in failure to maintain obstacle clearance. A factor was the high density altitude.NTSB DEN99LA155Accident · Minor injuriesLimited investigationFinal reportNorth American SNJ-4 (AT-6) · Mack, COThe pilot misjudging his distance and altitude from the runway. A factor was the tall crops.NTSB CHI99LA330Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75 · Sparta, ILThe pilot's decision not to use all of the available. A factor to the accident was the ditch.NTSB CHI99LA318Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Watervliet, MIthe pilot not maintaining aircraft control during takeoff, and the pilot not correcting for the porpoise.NTSB CHI99LA317Accident · No injuriesLimited investigationFinal reportAyres S-2R · Brooten, MNthe compressor impeller failure and the unsuitable terrain for landing encountered by the pilot.NTSB CHI99LA316Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Osceola, WIthe pilot's improper preflight decision to attempt a takeoff with one engine inoperative.NTSB CHI99LA313Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Pawnee City, NEThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB ANC99LA127Accident · No injuriesLimited investigationFinal reportMaule M-7 · Kotzebue, AKAn in-flight collision with a bird.NTSB MIA99WA240Accident · 2 fatalForeign investigationRobinson R22B · Cornakelly, IrelandNTSB MIA99LA239Accident · No injuriesLimited investigationFinal reportCessna 172N · Olive Branch, MSthe pilot misjudged the flare, resulting in the nose gear impacting the runway, and a bounced landing.NTSB LAX99LA286Accident · No injuriesLimited investigationFinal reportCessna 177 · Carson City, NVThe pilot's use of an excessive approach reference airspeed, his misjudged landing flare, and subsequent hard landing/porpoise. A contributing factor was the airplane's excessive approach airspeed.NTSB FTW99LA242Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Grapevine, TXThe pilot's failure to maintain directional control of the aircraft during landing.NTSB CHI99LA314Accident · No injuriesLimited investigationFinal reportBeech 58 · Chesterfield, MOthe inadvertent retraction of the landing gear by the pilot.NTSB CHI99IA350Incident · No injuriesIncident investigationFinal reportBritish Aerospace Jetstream 3101 · South Bend, INthe right engine accessory section's splined gear spur gear failure during cruise flight.NTSB CHI99FA311Accident · 1 fatalField investigationFinal reportWalker Breezy · Janesville, WIthe inadvertent stall. A factor relating to this accident was the pilot's excessive climb rate.NTSB ATL99LA119Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Mountain City, TNA blocked fuel system vent that resulted in fuel starvation and the complete loss of engine power.NTSB ANC99LA125Accident · No injuriesLimited investigationFinal reportLearjet 35 · Glennallen, AKThe pilot-in-command's delay in applying remedial action. A factor associated with the accident was the second-in-command's failure to maintain proper airspeed during final approach.NTSB SEA99LA149Accident · 1 fatalLimited investigationFinal reportBell 47G-2 · Benton City, WAA loss of power for undetermined reasons and the failure of the pilot to maintain adequate rotor RPM following the power loss. Contributing factors were the pilot's lack of certification and total experience.NTSB NYC99LA212Accident · No injuriesLimited investigationFinal reportCessna 150 · Madison, OHThe pilot's delay in using carburetor heat which resulted in a partial loss of engine power, and a forced landing.NTSB LAX99LA284Accident · No injuriesLimited investigationFinal reportAerospatiale AS350B3 · Long Beach, CAThe failure of the pilot to maintain clearance with the fence while landing. A factor was the failure of the helipad to meet the obstacle clearance design criteria specified in FAA Advisory Circular guidance.NTSB IAD99WA060Accident · 1 fatalForeign investigationCessna 206G · Nairobi, KenyaNTSB FTW99LA240Accident · Serious injuriesLimited investigationFinal reportBell 206-L3 · Main Pass 225aThe pilot's failure to maintain directional control of the helicopter. A factor was the tailwind condition.NTSB DCA99WA078Incident · No injuriesForeign investigationBoeing 737-200 · Durban, South AfricaNTSB CHI99LA312Accident · No injuriesLimited investigationFinal reportCessna 172M · Bloomington, ILthe pilot's inadequate visual lookout and not performing a maneuver to avoid obstructions. A factor was the road signs.NTSB NYC99LA211Accident · Serious injuriesLimited investigationFinal reportAeromot AMT-300 · Block Island, RIThe pilot's failure to abort the takeoffNTSB NYC99FA214Accident · 4 fatalField investigationFinal reportCessna 172N · Dyke, VAThe pilot's inadvertent flight into instrument meteorological conditions, which resulted in his inability to see the rapidly rising terrain. A factor was the pilot's inaccurate evaluation of the weather.NTSB MIA99LA238Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Jackson, ALthe pilot's inadequate preflight planning and preparation, which resulted in taking off with the airplane's maximum gross weight exceeded, and subsequent impact with trees. Factors in this accident were high temperatures and an in-flight encounter with a…NTSB MIA99LA237Accident · No injuriesLimited investigationFinal reportDinkel-Brook SEA REY · Orlando, FLthe pilot's failure to maintain control of the airplane resulting in an inadvertent stall at too low an altitude to recover.NTSB LAX99LA283Accident · No injuriesLimited investigationFinal reportBell UH-1B · Lost Hills, CAFailure and separation of the 90-degree gearbox as a result of the disengagement of the pinion and gear teeth. The cause(s) of the pinion and gear disengagement were undetermined.NTSB FTW99LA239Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Hart, TXThe pilot's failure to maintain clearance with power lines.NTSB CHI99LA309Accident · 1 fatalLimited investigationFinal reportPinick Horizon 2 · Grain Valley, MOThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Contributing to the accident was the pilot's lack of experience in this type of airplane.NTSB ANC99LA124Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Iliamna, AKThe pilot's selection of an unsuitable takeoff area, and an inadvertent stall. Factors associated with the accident were large wave/swells, and low light conditions (dawn).NTSB SEA99IA148Incident · No injuriesIncident investigationFinal reportEmbraer ERJ-135 · Moses Lake, WAMinimum aircraft control exceeded during takeoff test flight, which resulted in dragging a wing on the runway surface.NTSB NYC99LA209Accident · Serious injuriesLimited investigationFinal reportMorrisey 2150A · Ellisburg, NYThe pilot's delay in applying carburetor heat which resulted in the loss of power, and his misjudgment of the flare during the forced landing.NTSB NYC99FA210Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Saddle Island, METhe pilot's failure to maintain altitude/clearance from trees.NTSB LAX99LA282Accident · No injuriesLimited investigationFinal reportAerospatiale AS350BA · Kahului, HIThe pilot's initial misjudgment of the wind speed and his decision to continue a downwind landing approach when his speed and altitude profile was inadequate, and his failure to maintain main rotor rpm, resulting in settling with power and a hard landing.NTSB LAX99LA281Accident · Minor injuriesLimited investigationFinal reportAyres S2R-G10 · Stanfield, AZThe pilot's delay in aborting the takeoff after noting sluggish acceleration during the takeoff roll, which resulted in a runway overrun.NTSB FTW99LA236Accident · Minor injuriesLimited investigationFinal reportAeronca 7DC · Helena, ARThe student pilot's failure to maintain clearance from a tree. A factor associated with the accident was the pilot's low altitude.NTSB DCA99WA080Incident · No injuriesForeign investigationBoeing 767 · Copenhagen, DenmarkNTSB DCA99RA074Accident · 1 fatalForeign investigationMcDonnell Douglas MD-90 · Hualien, TaiwanNTSB SEA99LA145Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Yellow Pine, IDMisjudged approach resulting in landing long. Factors include an intentional ground-loop, excessive airspeed and an embankment.NTSB SEA99FA146Accident · 2 fatalField investigationFinal reportRepublic RC-3 · Chimacum, WAThe inadequate visual lookout by both the pilot-in-command and second pilot, and the pilot-in-command's failure to maintain sufficient flying speed to prevent a stall condition. Contributing factors were the transmission lines, gusty wind conditions, and the…NTSB MIA99LA235Accident · No injuriesLimited investigationFinal reportCessna 172P · Hampton, GAWas the failure of the pilot-in-command to maintain directional control after touchdown following a bounced landing, resulting in the on-ground collision with a taxiway sign and the separation of the right main landing gear.NTSB MIA99LA234Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Robbins, TNThe total loss of engine power due to failure of maintenance personnel to assure that the thru bolt nut at the Nos. 2 and 3 cylinders was adequately torqued following removal and replacement of the No. 3 cylinder approximately 328 hours earlier. Also, the…NTSB LAX99LA285Accident · No injuriesLimited investigationFinal reportBurkhart Grob G 103 Twin II · Llano, CAThe pilot's encounter with a sudden and violent dust devil, which caused the student pilot to lose control of the aircraft during the landing flare/touchdown.NTSB IAD99IA059Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Washington, DCThe inadequate lubrication of the landing gear side strut assembly by company maintenance personnel. A factor in the accident was the inadequate design of the assembly that trapped water and prevented adequate lubrication.NTSB FTW99LA245Accident · No injuriesLimited investigationFinal reportCessna 150K · Springdale, ARThe inadequate visual lookout by both pilots.NTSB FTW99LA234Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Russellville, ARThe improper touchdown by the flight instructor.NTSB FTW99FA235Accident · 1 fatalField investigationFinal reportBeech D-35 · Seminole, OKThe loss of engine power caused by oil starvation, which resulted in the failure of the #6 cylinder connecting rod bolts. A factor was the pilot's performance of an evasive maneuver to avoid impacting buildings, trees, people on the ground, and power lines.NTSB DCA99RA073Accident · Minor injuriesForeign investigationMcDonnell Douglas MD-11 · Hong Kong, China