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 ANC05LA136Accident · No injuriesLimited investigationFinal reportCessna 207 · Kotzebue, AKThe failure of the nose gear steering mechanism during the landing roll, which resulted in a loss of control and subsequent encounter with the runway.NTSB ANC05LA133Accident · No injuriesLimited investigationFinal reportCessna 206 · Yakutat, AKThe pilot's selection of unsuitable terrain for takeoff, and his failure to maintain adequate airspeed during takeoff initial climb from a remote airstrip, which resulted in the airplane descending to the ground and colliding with soft terrain beyond the end…NTSB SEA05LA185Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Mead, WASeparation of the tailwheel assembly spring resulting in a loss of directional control and subsequent collision with a berm. The berm was a factor in the accident.NTSB LAX05CA287Accident · No injuriesData collectionFinal reportCessna A185E · San Andreas, CAthe pilot's failure to maintain directional control of the airplane upon encountering a dust devil during the takeoff roll.NTSB LAX05CA285Accident · No injuriesData collectionFinal reportBellanca 7ECA · Malibu, CAa partial loss of engine power for undetermined reasons.NTSB LAX05CA284Accident · Serious injuriesData collectionFinal reportSchweizer SGS-2-32 · Waialua, HIthe pilot's inadvertent spin entry while practicing a stall maneuver and his failure to regain control of the glider before impacting a lake.NTSB IAD05LA129Accident · Minor injuriesLimited investigationFinal reportDassault/Sud Falcon 20D · Lorain, OHThe ingestion of multiple birds in each engine at takeoff, which resulted in a complete loss of engine power.NTSB DFW05WA227Accident · 8 fatalForeign investigationPiper PA-31-350 · Bogota, ColombiaNTSB DFW05LA252Accident · Minor injuriesLimited investigationFinal reportBell 206B · Myrtle Grove, LAThe pilot's loss of control in flight for undetermined reasons.NTSB CHI05LA250Accident · 1 fatalLimited investigationFinal reportPorterfield FP-65 · Sedalia, MOThe pilot's failure to maintain sufficient airspeed and the inadvertent stall/spin resulting in an in-flight loss of control and collision with terrain.NTSB LAX05LA324Accident · 2 fatalLimited investigationFinal reportPiper PA-18-150 · Mountain City, NVThe pilot's failure to maintain airspeed while maneuvering in mountainous terrain, which led to a stall and impact with trees and terrain.NTSB LAX05LA283Accident · 1 fatalLimited investigationFinal reportAvions Robin R.2160 · Avalon, CAThe flight instructor's unsuccessful recovery from a spin. The underlying reason was not determined.NTSB DFW05WA228Accident · 4 fatalForeign investigationPiper PA-23-250 · Cieneguilla, BoliviaNTSB DFW05CA225Accident · No injuriesData collectionFinal reportAyres S2R-T15 · Taylor, TXThe pilot's misjudgement while landing resulting in an overrun. A factor was fluctuating engine power.NTSB DEN05LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Ogden, UTthe flight instructor's failure to maintain adequate airspeed resulting in an inadvertent stall. Contributing factor's include the flight instructor's improper pre-flight planning and decision in accepting the intersection departure, and the flight…NTSB CHI05TA251Accident · No injuriesFinal reportCessna 182R · New Ulm, MNThe loss of engine power for undetermined reasons resulting in a forced landing. A contributing factor was the soft terrain condition.NTSB ATL05LA156Accident · No injuriesLimited investigationFinal reportCessna 172S · Opa Locka, FLA loss of engine power for undetermined reasons.NTSB LAX05CA282Accident · No injuriesData collectionFinal reportBellanca 7ECA · San Jose, CAthe pilot's failure to maintain directional control of the airplane during the landing flare, which resulted in a collision with an runway sign.NTSB SEA05LA184Accident · No injuriesLimited investigationFinal reportAirbus Industrie A330-223 · Portland, ORThe failure of the flightcrew of the other airplane to maintain clearance while taxiing.NTSB LAX05LA281Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob Flugzeugbau G102 Club Astir Iiib · Minden, NVthe student pilot's failure to ensure that the canopy was properly latched prior to departure. The inadequate supervision of the flight by the instructor and flight school was also causal.NTSB DFW05CA224Accident · No injuriesData collectionFinal reportCessna 152 · Tulsa, OKThe pilot's improper recovery from a bounced landing. A contributing factor was the dark night conditions.NTSB CHI05CA246Accident · No injuriesData collectionFinal reportAyres S2R-G10 · Davenport, NDThe pilot failed to gain suffient altitude during takeoff in order to clear the corn crop at the end of the runway. A factor associated with the accident was the corn crop.NTSB CHI05CA245Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Hector, MNThe pilot's failure to achieve adequate airspeed on takeoff which resulted in the airplane entering a stall/mush when it flew out of ground effect while crossing a large drainage ditch on takeoff.NTSB ANC05LA130Accident · No injuriesLimited investigationFinal reportCessna 441 · Anchorage, AKThe pilot's failure to lower the airplane's landing gear during landing, which resulted in an inadvertent wheels up landing.NTSB ANC05CA132Accident · No injuriesData collectionFinal reportCessna 172 · Tyonek, AKThe pilot's inadequate compensation for wind conditions during takeoff-initial climb, which resulted in a loss of control, and subsequent in-flight collision with a creek. A factor associated with the accident is a sudden windshift.NTSB ANC05CA131Accident · No injuriesData collectionFinal reportMaule M-5-210C · Fairbanks, AKThe pilot's inadequate compensation for wind conditions during the landing roll, which resulted in a loss of control and subsequent collapse of the main landing gear. Factors associated with the accident were a crosswind, and a steep drop-off.NTSB CHI05LA243Accident · 1 fatalLimited investigationFinal reportAllensworth Baby Belle · El Dara, ILThe manufacturer failed to specify a relief radius on the tail rotor spindle drawings, which resulted in the spindle being manufactured with an inadequate relief radius at the point of fatigue failure.NTSB CHI05CA248Accident · No injuriesData collectionFinal reportPiper PA-28-180 · McConnell, ILThe pilot's inadequate preflight/planning which resulted in the attempted takeoff on the soft airstrip. Factors associated with the accident were the soft terrain, the corn crop, and the inadequate airspeed achieved during the takeoff roll.NTSB CHI05CA247Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Ypsilanti, MIThe pilot's failure to maintain adequate airspeed which resulted in his inability to properly flare the airplane and the subsequent hard landing.NTSB ATL05LA154Accident · 2 fatalLimited investigationFinal reportSamson Seawind 3000 · Wrightsville Bh, NCThe pilot's improper preflight decision to attempt night VFR flight into IMC, which resulted in an inflight encounter with weather and the pilot's subsequent loss of control of the airplane due to spatial disorientation.NTSB ATL05CA155Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Destin, FLThe loss of engine power for undetermined reasons.NTSB SEA05FA181Accident · 2 fatalField investigationFinal reportPiper PA-14 · Challis, IDThe pilot's failure to maintain aircraft control and the subsequent inadvertent stall/spin to the ground. A contributing factor was the pilot's diverted attention while spotting/locating Rocky Mountain Bighorn sheep.NTSB SEA05CA183Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Chiloquin, ORThe failure of the left chain link which permits the pilot to control the tailwheel, and the subsequent inability of the pilot to control the airplane during the landing roll.NTSB SEA05CA182Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Boise, IDInadequate communications between the certified flight instructor and student pilot, and the student pilot's delay in relinquishing controls resulting in a hard landing during a practice autorotation.NTSB NYC05LA139Accident · No injuriesLimited investigationFinal reportTerrio Pober Jr Ace · Oxford, CTA fractured oil pressure line, which resulted in the fracture of the number 3 cylinder connecting rod bearing, and subsequent loss of engine power.NTSB NYC05FA138Accident · 1 fatalField investigationFinal reportCessna 172C · Winthrop, METhe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to fuel exhaustion, and a subsequent forced landing and impact with terrain.NTSB IAD05FA146Accident · 3 fatalField investigationFinal reportPiper PA-28RT-201 · Dunkirk, NYLoss of control for undetermined reasons.NTSB IAD05CA128Accident · No injuriesData collectionFinal reportPresley RV-4 · Biddeford, METhe pilot's failure to maintain directional control. Contributing to the accident was the wind gusts.NTSB DEN05CA132Accident · No injuriesData collectionFinal reportCessna 180J · Afton, WYloss of engine power for reasons undetermined.NTSB IAD05LA126Accident · 1 fatalLimited investigationFinal reportCessna 172H · Corry, PAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall and collision with terrain.NTSB LAX05LA279Accident · Minor injuriesLimited investigationFinal reportBeech 35-A33 · Alturas, CAThe loss of engine power for undertermined reasons.NTSB LAX05CA280Accident · No injuriesData collectionFinal reportPiper PA-28-236 · San Martin, CAthe pilot's failure to maintain directional control of the airplane during the landing roll. A factor in the accident was the spongy brakes.NTSB DEN05LA130Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Falcon, COthe pilot's failure to maintain control of the helicopter while conducting a hovering maneuver.NTSB CHI05CA244Accident · No injuriesData collectionFinal reportCessna 414 · Drummond Island, MIThe right main gear collapsed due to undetermined reasons. A factor associated with the accident was the fence that the airplane contacted.NTSB SEA05FA180Accident · 1 fatalField investigationFinal reportMaule Bee Dee M-4 · Ritter, ORThe loss of control for an undetermined reason which resulted in a ground collision.NTSB NYC05LA137Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-D · Sandy Lake, PAA total failure of the engine driven fuel pump, and the pilot's failure to recognize a diminishing fuel supply in the fuselage (header) fuel tank, which resulted in a total loss of engine power during cruise flight and subsequent collision with trees during a…NTSB ATL05CA153Accident · No injuriesData collectionFinal reportCessna 172S · Savannah, GAThe instructor's inadequate supervision and failure to maintain directional control, resulting in an on ground collision with terrain.NTSB NYC05CA136Accident · Minor injuriesData collectionFinal reportHanek Pitts S1S · Mercer, PAThe pilot's failure to maintain directional control during takeoff, which resulted in an on ground encounter with crops. A factor in this accident was the crosswind condition, as reported by the pilot.NTSB LAX05TA277Accident · Minor injuriesFinal reportWSK PZL Mielec M-18A · Elko, NVthe pilot's failure to adequately plan for the wind direction and speed during a fire retardant delivery flight, which led to a loss of true airspeed, failure to attain a proper climb rate, and the in-flight collision with mountainous terrain. Contributing…NTSB IAD05RA127Accident · 45 fatalForeign investigationBoeing 737-200 · Pucallpa, Peru