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 CHI00LA274Accident · Minor injuriesLimited investigationFinal reportWidner Pietenpol Aircamper · Andover, MNThe trees and the unsuitable terrain for landing encountered during the forced landing. Factors were the side slip to avoid the trees initiated by the pilot, the fractured piston, and the cracked cylinder.NTSB MIA00LA253Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Chatom, ALthe pilot's improper preflight planning/decision and failure to ensure an adequate supply of fuel to safely complete the flight to his destination with adequate fuel reserves, which resulted in fuel exhaustion, subsequent engine failure, and a forced landing…NTSB MIA00LA252Accident · 1 fatalLimited investigationFinal reportPitts S1-T · Vero Beach, FLthe pilot's failure to maintain control in flight, which resulted in an uncontrolled descent, and collision with the ground.NTSB LAX00LA321Accident · No injuriesLimited investigationFinal reportFogerson Richard D RV-6A · El Monte, CAThe loss of engine power for undetermined reasons.NTSB LAX00LA313Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Cameron Park, CAfailure of the pilot to verify the seat latch was secure, resulting in the pilot's inability to reach the flight controls necessary to maintain directional control.NTSB LAX00FA314Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Poway, CAThe pilot's intentional flight into known adverse weather.NTSB CHI00LA280Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Bolivar, MOThe pilot failed to maintain directional control of the airplane on landing. A factor associated with the accident was the crosswind.NTSB CHI00LA272Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Plattsmouth, NEthe pilot's improper preflight planning, improper in-flight planning and decision not to land before exhausting the airplane's fuel. Factors relating to this accident were the power lines, the roadway, and the ditch.NTSB SEA00LA172Accident · Serious injuriesLimited investigationFinal reportCessna 411 · Boise, IDAircraft control was not maintained during approach for landing.NTSB NYC00LA242Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Nantucket, MAThe pilot's failure to maintain the proper glide path to the runway. Factors related to the accident were the fog conditions and the pilot’s fatigue.NTSB NYC00LA241Accident · No injuriesLimited investigationFinal reportFreund Wittman W10 · Valley City, OHThe pilot's failure to maintain aircraft control during the takeoff. A factor in this accident was the crosswind condition.NTSB MIA00WA249Accident · 10 fatalForeign investigationCessna 208B · La Fortuna, Costa RicaNTSB MIA00LA254Accident · No injuriesLimited investigationFinal reportBeech D-45 · Jacksonville, FLthe pilot's improper landing flare which resulted the right wing dropping and impacting the runway.NTSB MIA00LA251Accident · Minor injuriesLimited investigationFinal reportRyan Navion A · Daytona Bch Sh, FLa loss of engine power due to undetermined reasons, that resulted in the aircraft being ditched.NTSB MIA00LA250Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-105 · Cullman, ALfailure of the pilot to maintain directional control of the aircraft during the landing rollout, which resulted in a ground swerve, and the aircraft exiting the runway and incurring substantial damage when it collided with a dirt bank.NTSB LAX00LA317Accident · No injuriesLimited investigationFinal reportSteinke Early Bird -JENNY · Chino, CAThe engine lost power for undetermined reasons and nosed over in a soft field during the resulting forced landing.NTSB LAX00LA312Accident · 1 fatalLimited investigationFinal reportCable-Breigler BG-12BD · Tehachapi, CAThe pilot exceeded the airspeed limit for operation of the flaps resulting in flap and wing overload and separation.NTSB LAX00LA311Accident · No injuriesLimited investigationFinal reportPerrucci Randall J Revolution MINI-500 · Gridley, CAThe fracture and separation of a control rod in the cyclic flight control system.NTSB LAX00FA310Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Hilo, HIDeterioration and failure of the oil filter converter plate gasket, which resulted in a loss of engine power and a subsequent in-flight fire.NTSB IAD00LA070Accident · Minor injuriesLimited investigationFinal reportJordan Kitfox Model 1 · Waynesville, OHA broken carburetor jet needle, which blocked fuel from entering the carburetor's mixing tube and resulted in a partial loss of engine power.NTSB CHI00LA273Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Parsons, KSthe pilot not maintaining clearance from the fence post and not attaining the proper touchdown point. A factor was the fence post.NTSB CHI00LA271Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Superior, NEthe cracked number 7 cylinder exhaust valve. A factor relating to this accident was the tree.NTSB SEA00LA171Accident · No injuriesLimited investigationFinal reportCessna 180H · Roche Harbor, WAThe pilot's failure to adequately compensate for wind conditions during landing.NTSB SEA00LA170Accident · No injuriesLimited investigationFinal reportHughes 369E · Coolin, IDThe turbine outlet temperature indicating system was out of calibration. Factors included improper maintenance calibration, which resulted in the over temperature of the turbine assembly.NTSB NYC00FA240Accident · Serious injuriesField investigationFinal reportPiper PA-44-180 · Lake Hopatcong, NJThe flight instructor's improper placement of both fuel-selector switches, which resulted in a total loss of engine power on both engines.NTSB NYC00FA239Accident · Serious injuriesField investigationFinal reportCessna 206H · Mayville, NYAn engine compartment explosion due to a fuel/fuel vapor leak of undetermined origin. A secondary explosion resulted from a lack of lubrication to the number 6 connecting rod bearing. Contributing to the pilot's injuries was his reduced visibility during the…NTSB MIA00WA277Accident · No injuriesForeign investigationSwearingen SA-226TC · Rosario, ArgentinaNTSB MIA00LA248Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Niceville, FLThe pilots failure to drop the advertising banner prior to a precautionary landing resulting in the aircraft stalling and landing hard. Contributing to the accident was the pilots failure to maintain airspeed during climb after banner pickup resulting in the…NTSB MIA00LA247Accident · No injuriesLimited investigationFinal reportCessna 182Q · Fayetteville, TNthe pilot's failure to maintain adequate airspeed during the takeoff/initial climb, which resulted in an inadvertent stall/mush and collision with the runway that resulted in substantial damage to the airplane.NTSB CHI00LA270Accident · Minor injuriesLimited investigationFinal reportRaven AS-55A · Lincoln, ILThe pilot failed to maintain clearance with the power lines. Factors associated with the accident were the pilot's attention was diverted and the power lines which the balloon contacted.NTSB SEA00LA197Accident · No injuriesLimited investigationFinal reportBell 206BII · Newhalem, WADebonding between the elastomeric material and the center plate of the transmission isolation mount.NTSB LAX00LA357Accident · No injuriesLimited investigationFinal reportCessna 182G · Fallon, NVA hard landing by a pilot of a previous flight. Additional causes of the accident were an undershoot that resulted in a hard landing, and the CFI's failure to adequately supervise the flight.NTSB FTW00LA242Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-35 · Corsicana, TXthe in-flight separation of the propeller blade, which resulted from intergranular corrosion and fatigue cracking.NTSB FTW00FA245Accident · 1 fatalField investigationFinal reportCessna 421C · Hunt, TXthe loss of left engine power as a result of the owner's failure to overhaul the engine before further flight after the lubrication system was found contaminated with metal. Contributing factors were the pilot's decision to fly the aircraft with a…NTSB ANC00LA108Accident · 3 fatalLimited investigationFinal reportCessna 180 · Pilot Point, AKThe commercial certificated pilot, an owner of a fishing lodge, departed a remote area of beach with three passengers to return to the lodge. The accident airplane was one of two airplanes transporting lodge guests. The beach was located along an area of…NTSB NYC00RA249Accident · 2 fatalForeign investigationRobinson R-22 · DenmarkNTSB NYC00LA238Accident · No injuriesLimited investigationFinal reportAviat A-1B · Newberryport, MAthe failure of the pilot to maintain directional control during landing and a subsequent rejected landing. Factors were the crosswind, and the delayed corrective action by the pilot.NTSB MIA00WA246Accident · 3 fatalForeign investigationCessna 207 · Marieta, VenezuelaNTSB MIA00LA245Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Berlin, GAthe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall and collision with terrain.NTSB MIA00LA244Accident · No injuriesLimited investigationFinal reportSiai-Marchetti F260B · Meridianville, ALthe pilot's inadequate preflight planning/preparation which resulted in fuel contamination going undetected, which resulted in a forced landing and substantial damage to the aircraft during the emergency landing.NTSB LAX00FA324Accident · 2 fatalField investigationFinal reportBellanca 17-30 · Scottsdale, AZthe pilot's failure to maintain adequate terrain clearance during a cruise descent, which resulted in controlled flight into mountainous terrain during dark night conditions. Contributing factors were the rain, thuderstorm, and dust storm weather conditions,…NTSB FTW00LA244Accident · Serious injuriesLimited investigationFinal reportBoeing 757-223 · Gulf Of Mexicothe flight crew's inadvertent encounter with convective turbulence while in cruise flight. A factor was the rapidly developing convective activity.NTSB DEN00LA157Accident · Serious injuriesLimited investigationFinal reportPhelps Rans S-12 Airaile · Buffalo, WYthe lack of suitable terrain for the forced landing. Contributing factors were the power failure due to a failed rod bearing, and down draft weather condition.NTSB DCA00RA083Accident · 143 fatalForeign investigationAirbus Industrie A320 · Manama, BahrainNTSB CHI00FA265Accident · 3 fatalField investigationFinal reportCessna 340A · Mission, SDthe aircraft control not maintained by the pilot. A contributing factor was pilot fatigue.NTSB NYC00LA235Accident · No injuriesLimited investigationFinal reportCessna 150F · Friendly, MDThe pilot's inability to locate the airport, which resulted in fuel exhaustion. A factor related to the accident was the night light conditions.NTSB CHI00LA268Accident · Serious injuriesLimited investigationFinal reportBoeing 777-223 · Baraboo, WIthe unexpected turbulence encountered by the airplane.NTSB ANC00LA111Accident · No injuriesLimited investigationFinal reportCessna 172 · Alexander Creek, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident were gusty winds, and a downdraft.NTSB ANC00LA107Accident · No injuriesLimited investigationFinal reportCessna 182 · Golovin, AKThe pilot's inadequate compensation for wind conditions. A factor associated with the accident was a crosswind.NTSB SEA00LA169Accident · Serious injuriesLimited investigationFinal reportClearwaters RAF 2000 · Leahy, WAA loss of control for undetermined reasons.