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.

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.Jul 1, 1994 · N24201 · Substantial damageNTSB NYC94LA112Accident · No injuriesLimited investigationFinal reportCessna 172 · Tinton Falls, NJThe loss of engine power for undetermined reasons.Jul 1, 1994 · N6979X · Substantial damageNTSB 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.Jul 1, 1994 · N5482K · Substantial damageNTSB 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.Jul 1, 1994 · N6375P · DestroyedNTSB 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.Jul 1, 1994 · N4287L · DestroyedNTSB LAX94T#A06Accident · No injuriesClass 3Final reportBell 206-B3 · Tucson, AZJul 1, 1994 · N10800 · DestroyedNTSB 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.Jul 1, 1994 · N748CB · Substantial damageNTSB 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.Jul 1, 1994 · N6568 · Substantial damageNTSB 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.Jul 1, 1994 · N815MC · Substantial damageNTSB CHI94LA218Accident · No injuriesLimited investigationFinal reportCallair A9B · Minot, NDthe pilot's failure to maintain clearance from the wheat field. A factor was the turbulence.Jul 1, 1994 · N2851F · Substantial damageNTSB 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.Jul 1, 1994 · N7472X · DestroyedNTSB 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.Jul 1, 1994 · N373X · Substantial damageNTSB 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.Jul 1, 1994 · N8510C · DestroyedNTSB 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…Jun 30, 1994 · N76UT · Substantial damageNTSB 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.Jun 30, 1994 · N4359C · Substantial damageNTSB 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.Jun 30, 1994 · N733AA · DestroyedNTSB 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.Jun 30, 1994 · N526Y · Substantial damageNTSB 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.Jun 30, 1994 · N30342 · Substantial damageNTSB 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.Jun 30, 1994 · N1404Z · Substantial damageNTSB 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.Jun 30, 1994 · N6966Q · Substantial damageNTSB 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.Jun 30, 1994 · N7041Y · DestroyedNTSB 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).Jun 29, 1994 · N606TW · No damageNTSB 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…Jun 29, 1994 · N1752K · Minor damageNTSB 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.Jun 29, 1994 · N4230X · DestroyedNTSB FTW94LA218Accident · Serious injuriesLimited investigationFinal reportCessna 182K · Collbran, COAn inadvertent stall. Factors were a partially blocked pitot tube and a downdraft.Jun 29, 1994 · N2580Q · DestroyedNTSB CHI94DTG02Accident · No injuriesFinal reportAir Tractor AT301 · Lawton, NDThe pilot's improper use of carburetor heat. The carburetor icing weather condition was a factor.Jun 29, 1994 · N4349S · Substantial damageNTSB BFO94LA123Accident · No injuriesLimited investigationFinal reportSchweizer 2-33 · Waynesville, OHThe instuctors inadequate supervision of the student who misjudged distance/altitude.Jun 29, 1994 · N65807 · Substantial damageNTSB 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.Jun 29, 1994 · N9313S · Substantial damageNTSB BFO94FA121Accident · 3 fatalField investigationFinal reportBeech 58TC · St Marys, WVAn in-flight fire of undetermined origin, prior to the in-flight breakup.Jun 29, 1994 · N333TK · DestroyedNTSB 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.Jun 29, 1994 · N41185 · Substantial damageNTSB 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.Jun 28, 1994 · N5512N · Substantial damageNTSB 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,…Jun 28, 1994 · N2132W · DestroyedNTSB 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.Jun 28, 1994 · N3042V · DestroyedNTSB BFO94LA119Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Germansville, PAThe pilot failed to maintain a proper descent rate which resulted in an undershoot.Jun 28, 1994 · N3807M · Substantial damageNTSB 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.…Jun 28, 1994 · N6004E · DestroyedNTSB SEA94LA170Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Prineville, ORThe pilot's inadequate compensation for wind conditions. A factor was gusty wind conditions.Jun 27, 1994 · N3992P · Substantial damageNTSB 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.Jun 27, 1994 · N109KM · Substantial damageNTSB MIA94LA168Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Walls, MSThe partial loss of engine power for undetermined reasons. The sandy terrain was a factor.Jun 27, 1994 · N45332 · Substantial damageNTSB 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.Jun 27, 1994 · N500JD · DestroyedNTSB ATL94LA127Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Finley, TNThe loss of engine power for undetermined reasons. Factors were wet and soft terrain.Jun 27, 1994 · N36484 · Substantial damageNTSB LAX94T#A07Accident · No injuriesClass 3Final reportMcDonnell Douglas OH-6A · Ocotillo, CAJun 26, 1994 · N5473X · Substantial damageNTSB LAX94T#A05Accident · No injuriesClass 3Final reportBell 206-B3 · Indian Springs, NVJun 26, 1994 · N444EB · Substantial damageNTSB FTW94T#A01Accident · No injuriesClass 3Final reportBell 206A · Estes Park, COJun 26, 1994 · N7881S · Substantial damageNTSB 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.Jun 26, 1994 · N5183E · Substantial damageNTSB 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.Jun 26, 1994 · N1175S · Substantial damageNTSB 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.Jun 26, 1994 · N6728X · Substantial damageNTSB BFO94LA116Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Massena, NYThe pilot's improper compensation for wind conditions.Jun 26, 1994 · N5435K · Substantial damageNTSB 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.Jun 25, 1994 · N63419 · Substantial damageNTSB FTW94LA211Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Dumas, ARThe pilot's failure to establish the proper airspeed before beginning a turn after takeoff.Jun 25, 1994 · N4222P · DestroyedNTSB 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.Jun 25, 1994 · N51CC · Substantial damage