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 SEA94LA165Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mccall, IDThe pilot's inadequate preflight planning and attempted operation which exceeded the performance capability of the airplane. Factors include his overconfidence in the aircraft's ability.NTSB NYC94LA112Accident · No injuriesLimited investigationFinal reportCessna 172 · Tinton Falls, NJThe loss of engine power for undetermined reasons.NTSB NYC94LA104Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Greenville, METhe premature retraction of the wing flaps by the pilot after takeoff, resulting in a loss of lift and collision with trees.NTSB NYC94LA103Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Monmouth Beach, NJA power loss due to fuel starvation, for undetermined reasons. A factor was the night conditions.NTSB MIA94LA170Accident · 1 fatalLimited investigationFinal reportFullana Quicksilver GT-500 · Palmas Del Mar, PRThe pilot's abrupt lowering of the flaps which resulted in a loss of control at an altitude insufficient for recovery, and the pilot's unwarranted low flying.NTSB LAX94T#A06Accident · No injuriesClass 3Final reportBell 206-B3 · Tucson, AZNTSB FTW94LA219Accident · No injuriesLimited investigationFinal reportCameron V-77 · Littleton, COA total failure of the balloon's heater system (pilot light) for undetermined reasons. A factor was unsuitable terrain on which to make a forced landing.NTSB FTW94LA217Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Marked Tree, ARThe power loss for undetermined reasons. Factors were the pilot's inadvertent entry into a stall and the lack of suitable terrain onto which to execute the landing.NTSB CHI94LA227Accident · No injuriesLimited investigationFinal reportCessna 441 · Flint, MIAn inadequate preflight inspection of the airplane by the pilot. Factors associated with this accident were unlatched nose cargo doors and the pilot's failure to extend the landing gear.NTSB CHI94LA218Accident · No injuriesLimited investigationFinal reportCallair A9B · Minot, NDthe pilot's failure to maintain clearance from the wheat field. A factor was the turbulence.NTSB CHI94LA216Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Shiocton, WIthe pilot's failure to maintain Vso during takeoff. Factors related to the accident was the disregard for performance data and trees.NTSB ANC94LA073Accident · No injuriesLimited investigationFinal reportMaule M-5 · Anchorage, AKThe pilot's improper landing technique which resulted in a hard landing, tire failure, and eventual loss of directional control.NTSB ANC94FA074Accident · 3 fatalField investigationFinal reportPiper PA-22 · Delta Junction, AKThe loss of engine power for undetermined reasons. A factor was the pilot did not maintain airspeed resulting in a stall/spin.NTSB NYC94FA106Accident · No injuriesField investigationFinal reportSikorsky S-76B · Newport, RIthe failure of the left hand helical gear in the main gear box (MGB), due to undertorqued attaching bolts installed by the manufacturer, which resulted in a partial MGB failure. This failure resulted in the loss of the number one engine, illumination of the…NTSB LAX94LA270Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · San Carlos, CAthe student pilot's attempt to exit the runway at an excessive taxi speed which resulted in his loss of control.NTSB LAX94LA269Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Schurz, NVthe pilot's inability to maintain an adequate airspeed in the takeoff initial climb due to an encounter with a windshear.NTSB FTW94LA216Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Searcy, ARThe total loss of engine power due to water contamination of the fuel system. A factor was the lack of suitable terrain available to the pilot for the forced landing and his inadequate preflight inspection.NTSB FTW94LA215Accident · No injuriesLimited investigationFinal reportPiper J4A · Granite Shoals, TXFuel system starvation due to the pilot's failure to secure the engine fuel primer. A factor was the lack of suitable terrain for the forced landing.NTSB CHI94LA214Accident · Minor injuriesLimited investigationFinal reportLake LA-250 · Jefferson City, MOthe pilot allowing the airplane to get into an uncontrolled porpoising situation. A factor related to the accident was the choppy water.NTSB CHI94LA213Accident · No injuriesLimited investigationFinal reportBeech 19 · Ionia, MIthe pilot's improper use of the throttle control. A factor related to the accident was the improper flare.NTSB BFO94LA124Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Sandy Hook, NJThe loss of engine power for reasons undetermined and the inability of the pilot to feather the propeller.NTSB NYC94LA111Accident · Serious injuriesLimited investigationFinal reportBoeing 767-200 · East Hampton, NYIn-flight encounter with turbulence in the vicinity of thunderstorms. A factor related to the accident was: improper planning/decision by the pilot(s).NTSB MIA94FA169Accident · Serious injuriesField investigationFinal reportMcdonnell Douglas MD-11 · CaribbeanThe reserve first officer's unauthorized movement of the first officer's seat during flight which resulted in the first officer's legs being forced against the control column, pushing it forward, and disconnecting the autopilot. This resulted in the aircraft…NTSB LAX94LA268Accident · 1 fatalLimited investigationFinal reportRockwell S2-R · Firebaugh, CAThe pilot's loss of aircraft control as a result of incapacitation from an in-flight sulfur fire.NTSB FTW94LA218Accident · Serious injuriesLimited investigationFinal reportCessna 182K · Collbran, COAn inadvertent stall. Factors were a partially blocked pitot tube and a downdraft.NTSB CHI94DTG02Accident · No injuriesFinal reportAir Tractor AT301 · Lawton, NDThe pilot's improper use of carburetor heat. The carburetor icing weather condition was a factor.NTSB BFO94LA123Accident · No injuriesLimited investigationFinal reportSchweizer 2-33 · Waynesville, OHThe instuctors inadequate supervision of the student who misjudged distance/altitude.NTSB BFO94LA122Accident · No injuriesLimited investigationFinal reportBeech C23 · Easton, MDThe flight instructor's inadequate supervision, resulting in a hard landing and a subsequent collapse of the nose gear. Also causal to the accident, was the student pilot's improper raising of the wing flaps during the landing flare.NTSB BFO94FA121Accident · 3 fatalField investigationFinal reportBeech 58TC · St Marys, WVAn in-flight fire of undetermined origin, prior to the in-flight breakup.NTSB ANC94LA072Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Sheldon Point, AKThe pilot's failure to attain a proper touchdown Point. Factor was the inadequate runway marking.NTSB LAX94LA267Accident · 1 fatalLimited investigationFinal reportAeronca 11AC · Wickenburg, AZLoss of engine power for an unknown reason, and failure of the pilot to maintain airspeed, which resulted in an inadvertent stall and collision with the ground.NTSB LAX94FA266Accident · 3 fatalField investigationFinal reportBeech C23 · Lakeport, CAFailure of the pilot to maintain adequate airspeed during go-around from an aborted landing, which resulted in an inadvertent stall. Factors related to the accident were: the pilot's misjudgment of speed and distance to the runway while on final approach,…NTSB CHI94FA212Accident · 3 fatalField investigationFinal reportBeech A35 · Lakeville, MNThe jamming of the elevator control which resulted in the pilot's inability to control the pitch attitude of the airplane. The airplane encountered a stall-spin and impacted level terrain in an uncontrolled descent.NTSB BFO94LA119Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Germansville, PAThe pilot failed to maintain a proper descent rate which resulted in an undershoot.NTSB BFO94FA120Accident · 2 fatalField investigationFinal reportBeech 76 · Elizabeth, PA1) The failure of the pilot-in-command (CFI) to provide adequate supervision of the dual student during a simulated single-engine approach, and 2) his failure to perform remedial action. This led to a loss of aircraft control in close proximity to the ground.…NTSB SEA94LA170Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Prineville, ORThe pilot's inadequate compensation for wind conditions. A factor was gusty wind conditions.NTSB SEA94LA156Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G-109B · Bend, ORThe pilot's impairment of judgment and performance due to drugs, which led to his failure to maintain control of the aircraft.NTSB MIA94LA168Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Walls, MSThe partial loss of engine power for undetermined reasons. The sandy terrain was a factor.NTSB FTW94LA213Accident · Serious injuriesLimited investigationFinal reportDerr TRI-Q-100 · Albuquerque, NMThe pilot's improper recovery from a bounced landing and his inability to maintain directional control. A factor was the high density altitude.NTSB ATL94LA127Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Finley, TNThe loss of engine power for undetermined reasons. Factors were wet and soft terrain.NTSB LAX94T#A07Accident · No injuriesClass 3Final reportMcDonnell Douglas OH-6A · Ocotillo, CANTSB LAX94T#A05Accident · No injuriesClass 3Final reportBell 206-B3 · Indian Springs, NVNTSB FTW94T#A01Accident · No injuriesClass 3Final reportBell 206A · Estes Park, CONTSB CHI94LA211Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Lambertville, MIthe pilot-in-command's not maintaining airspeed. A factor was the pilot-in-command's misjudging the flare.NTSB BFO94LA118Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS2-32 · Plymouth, MAThe pilot-in-command's improper in-flight planning and decision. A factor related to the accident is a downdraft.NTSB BFO94LA117Accident · No injuriesLimited investigationFinal reportBeech F33A · Quarryville, PAThe pilot's failure to touchdown at the proper point and his delayed remedial action. A factor related to the accident was a tailwind.NTSB BFO94LA116Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Massena, NYThe pilot's improper compensation for wind conditions.NTSB LAX94LA265Accident · No injuriesLimited investigationFinal reportCessna 180 · Elko, NVThe pilot's failure to maintain proper alignment during landing rollout. Factors in the accident were the presence of soft and uneven terrain adjacent to the landing site.NTSB FTW94LA211Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Dumas, ARThe pilot's failure to establish the proper airspeed before beginning a turn after takeoff.NTSB FTW94FA212Accident · Serious injuriesField investigationFinal reportPiper PA-46-350P · Akron, COThe loss of engine power due to oil exhaustion which resulted from a failed oil scraper ring. A factor was unsuitable terrain for a forced landing.