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 FTW94IA099Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-72 · Dfw Airport, TXThe blocked numer 1 engine drain manifold.NTSB FTW94FA091Accident · 4 fatalField investigationFinal reportCessna 310K · Wichita Falls, TXWas the loss of control due to the pilot's spatial disorientation following a complete electrical system failure. Factors were the dark night and the electrical failure as result of burned out wiring terminal.NTSB ANC94IA037Incident · No injuriesIncident investigationFinal reportBoeing 747-200F · Anchorage, AKThe attempt, by the pilot in command, to attempt takeoff with the parking brake controll engaged, resulting from incorrect procedures by the pilot in command.NTSB NYC94LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Falls Of Rough, KYThe pilot's inadequate tiedown and starting procedure which resulted in a runaway aircraft, which subsequently collided with a building.NTSB SEA94LA072Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Walla Walla, WAUnsuitable terrain for a forced landing after a loss of power due to a failed engine cylinder. Factors include a partial magneto failure.NTSB SEA94LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Casper, WYThe pilot's failure to maintain proper alignment with the runway. The crosswind was of factor.NTSB SEA94FA071Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Frenchglen, ORThe pilot's failure to maintain minimum airspeed (vs). The tailwind was a factor.NTSB LAX94LA146Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Merced, CAthe pilot's misjudgement of the descent rate and his delayed throttle application.NTSB FTW94FA090Accident · 1 fatalField investigationFinal reportCessna P337H · N. Little Rock, ARFailure of the pilot to maintain control of the aircraft, while maneuvering to land. Factors related to the accident were: darkness and possible spatial disorientation.NTSB DCA94MA038Accident · Minor injuriesClass 1 · MajorFinal reportMcdonnell Douglas MD-82 · Flushing, NYThe failure of the flightcrew to comply with checklist procedures to turn on an operable pitot/static heat system, resulting in ice and/or snow blockage of the pitot tubes that produced erroneous airspeed indications, and the flightcrew's untimely response to…NTSB CHI94LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Lindsborg, KSwas the pilot-in-command's failure to refuel the airplane during the flight. Factors were fuel exhaustion, the sign, and the pilot-in-command's lack of total experience in type of airplane.NTSB SEA94LA088Accident · No injuriesLimited investigationFinal reportMikoyan MiG MIG-17T · Aurora, ORFailure of a metal fuel line, resulting in an explosion.NTSB NYC94LA050Accident · Serious injuriesLimited investigationFinal reportBell 47G-5 · Plymouth, MAThe pilot's failure to maintain adequate clearance of the fuel truck from the aircraft, which resulted in the main rotor striking the fuel hose and truck during refueling operation. A factor was the pilot's failure to follow company policy pertaining to the…NTSB LAX94LA187Accident · 2 fatalLimited investigationFinal reportBell 206A · Pacific Ocean (Pacific Ocean)undetermined.NTSB FTW94LA088Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Longmont, COAn inadvertent stall due to improper preflight and the pilot's failure to adequately remove ice from the aircraft. A factor was airframe icing.NTSB DCA94RA037Accident · No injuriesForeign investigationBoeing 747 · Narita, JapanNTSB ATL94FA056Accident · 4 fatalField investigationFinal reportCessna P210R · Bay Minette, ALThe pilot's failure to maintain control of the aircraft due to spatial disorientation, and exceeding the design stress limits of the aircraft. Factors related to the accident were: the pilot's flight into known adverse weather conditions, overconfidence in…NTSB ANC94FA036Accident · No injuriesField investigationFinal reportLockheed L-1011 · Fairbanks, AKFailure of the sixth stage disc on the intermediate compressor stage 6/7TH rotor shaft assembly in the number three engine, due to corrosion pitting and fatigue cracking of the failed disc. A factor related to the accident was: failure of the airline company…NTSB SEA94LA069Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Hanksville, UTThe pilot's delay in releasing his tow line when the line became entangled with wires.NTSB LAX94IA145Incident · No injuriesIncident investigationFinal reportAerospatiale AS-350D · Huelo, HIThe operator maintenance personnel's inadequate 100-hour inspection. The loose fuel control line fitting, the tree stump, and the unsuitable terrain were factors in this accident.NTSB BFO94LA053Accident · No injuriesLimited investigationFinal reportPiper PA-24- 260 · Stow, MAThe pilot's failure to follow the checklist which resulted in fuel starvation and subsequent loss of engine power. The lack of suitable terrain to complete a forced landing was a factor.NTSB BFO94LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Bath, OHloss of engine power for undetermined reasons. A factor in the accident was the frozen, snow covered terrain.NTSB ATL94IA055Incident · No injuriesIncident investigationFinal reportCessna 421B · Lagrange, GAThe pilot's intentional swerve off the taxiway to avoid a ground collision. A factor in the incident was an undetermined malfunction of the airplane's normal brake system.NTSB SEA94LA068Accident · No injuriesLimited investigationFinal reportCessna 172 · Gillette, WYWas the pilot's inadequate remedial action. Factors include an inadvertent porpoise, and a lack of total experience.NTSB SEA94LA067Accident · No injuriesLimited investigationFinal reportCessna 150 · Clarkston, WAThe pilot in command's inadequate use of carburetor heat. Factor(s) were: carburetor icing weather conditions and rough terrain.NTSB SEA94LA066Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Nampa, IDThe pilot in command's failure to refuel the aircraft. Factor(s) contributing to the accident were: fuel exhaustion, lack of total experience in type aircraft, and terrain condition (ditch).NTSB LAX94LA140Accident · No injuriesLimited investigationFinal reportCessna 150 · Chandler, AZThe pilot's intentional swerve to avoid a large bird that flew toward the airplane during the landing roll.NTSB LAX94LA139Accident · No injuriesLimited investigationFinal reportBell 206B · Agua Dulce, CAThe cfi's selection of unsuitable terrain to demonstrate a simulated autorotation. The soft terrain was a factor in this accident.NTSB FTW94LA086Accident · 1 fatalLimited investigationFinal reportAir Tractor AT400 · Widener, ARThe pilot's loss of control for undetermined reasons.NTSB CHI94LA099Accident · No injuriesLimited investigationFinal reportCessna 172RG · Frankfort, MIThe failure of the pilot-in-command to maintain directional control. The snow covered runway was a factor.NTSB ANC94LA035Accident · No injuriesLimited investigationFinal reportCessna 402 · Kivalina, AKThe pilot's inadequate compensation for the wind conditions by landing on the left side of the runway. Factors were: inadequate snow removal and the snow covered runway.NTSB SEA94LA073Accident · Minor injuriesLimited investigationFinal reportBell 206 L-1 · Salt Lake City, UTThe pilot's selection of unsuitable terrain for a landing site. Factors include snow covered terrain.NTSB LAX94LA142Accident · No injuriesLimited investigationFinal reportWeber Q200 · Las Vegas, NVThe total failure of the tailwheel assembly. The rough/uneven terrain was a factor in this accident.NTSB FTW94LA087Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Almyra, ARThe partial failure of the brake master cylinder assembly for undetermined reasons. A factor was the soft terrain adjacent to the runway.NTSB CHI94LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · Concordia, KSthe flight instructor's inadequate remedial action when the student pilot failed to maintain adequate directional control of the airplane during the landing roll. A related factor is the drifted snow.NTSB CHI94IA095Incident · Minor injuriesIncident investigationFinal reportBritish Aerospace ATP · Mosinee, WIthe inadequate design of the PBSI electrical switch(es), and the operator's failure to expeditiously implement corrective Service Bulletins.NTSB ATL94LA054Accident · No injuriesLimited investigationFinal reportHelio HE391B · Saluda, SCThe pilot's and mechanic's failure to adequately inspect the aircraft fuel system which resulted in fuel starvation.NTSB MIA94LA081Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Miami, FLLoss of engine power for undetermined reasons.NTSB MIA94LA080Accident · No injuriesLimited investigationFinal reportCessna 150M · Pierson, FLThe failure of the pilot-in-command to maintain alignment with the runway and airspeed resulting in the aircraft stalling.NTSB LAX94LA196Accident · No injuriesLimited investigationFinal reportSchweizer 300C · Pacific Ocean (Pacific Ocean)The loss of engine power for undetermined reasons.NTSB LAX94LA170Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Santa Paula, CAthe existing meteorological conditions that were conducive to carburetor icing.NTSB SEA94LA065Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Gold Hill, ORSeparation of the crossover fuel line, and the inability of the pilot in command to maintain a proper rate of descent during the autorotation.NTSB MIA94WA079Accident · No injuriesForeign investigationPiper PA-23-250 · Tortola, British Virgin IslandsNTSB LAX94LA137Accident · Minor injuriesLimited investigationFinal reportWaco YMF-5 · Carlsbad, CAThe pilot's failure to follow the correct procedures when he released the parking brake. The inadvertently engaged parking brake and the outdated flight manual were factors in this accident.NTSB LAX94LA134Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS-350-B · Humuula, HIThe pilot's poor in-flight decision by failing to attain the best rate of climb speed and exceeding the helicopter's hover performance capability. The clouds and downdraft were factors in this accident.NTSB LAX94FA138Accident · 2 fatalField investigationFinal reportCessna 150L · San Jacinto, CAThe pilot's impairment of judgment and performance due to alcohol and drugs, which led to his improper planning/decision, and his failure to maintain altitude/clearance from mountainous terrain, while maneuvering at low altitude.NTSB FTW94LA089Accident · No injuriesLimited investigationFinal reportMooney M20J · Gallup, NMThe loss of engine power due to the failure of the number 3 exhaust valve. A factor was the lack of suitable terrain available to execute the forced landing.NTSB CHI94GA093Accident · 4 fatalFinal reportCessna 401A · Minot, NDFailure of the pilot to maintain proper altitude during a missed approach. Factors related to the accident were: the unfavorable weather and snow covered terrain.NTSB BFO94LA050Accident · No injuriesLimited investigationFinal reportBeech 400 · Cleveland, OHThe pilots failure to use the proper radio frequency to activate the airport runway lights, and the pilot's improper decision to continue his approach and land without the runway lights being on.NTSB SEA94LA064Accident · Minor injuriesLimited investigationFinal reportHiller-Soloy H-23D · Seaside, ORThe pilot's improper use of flight controls resulting in settling with power.