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 MIA94FA078Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Inverness, FLThe pilot-in-command's lack of total experience in instrument flight, simulated instrument flight, and night flight resulting in the pilot becoming spatially disoriented, and subsequent in-flight collision with terrain. Contributing to the accident was the…NTSB LAX94LA144Accident · No injuriesLimited investigationFinal reportCessna 421C · Tulare, CAthe pilot's use of an excessive taxi speed, and his misjudgment of the distance to the approaching intersection. A factor in the accident was the dark night lighting conditions which effected the pilot's perception of the taxiway layout.NTSB LAX94LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Santa Rosa, CAA failure of the pilot-in-command to ensure that the powerplant controls were configured properly before moving the aircraft propeller. Inadequate planning/decision making was a factor in this accident.NTSB LAX94LA133Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Clarksburg, CAThe total failure of the no. 1 cylinder due to fatigue resulting from an improperly adjusted mixture causing detonation. The soft, wet plowed field was a factor in this accident.NTSB LAX94LA132Accident · Minor injuriesLimited investigationFinal reportBell TH-1L · Etna, CAThe faituge of the gear tooth which caused the failure of the 42-degree gear box.NTSB FTW94LA085Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Eagle Lake, TXThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB ATL94LA053Accident · No injuriesLimited investigationFinal reportCessna T210R · Baxley, GADamage to the crankshaft internal oil tube by other maintenance persons during the engine overhaul that resulted in oil starvation.NTSB MIA94LA077Accident · No injuriesLimited investigationFinal reportCessna 150 · Tampa, FLThe student pilot's improper use of the flight controls and failure to maintain sufficient airspeed on final approach for landing resulting in an inadvertant stall and subsequent collision with terrain.NTSB DCA94WA036Accident · No injuriesForeign investigationBeech 2000 (Starship) · Roskilde, DenmarkNTSB BFO94LA047Accident · No injuriesLimited investigationFinal reportCessna 172M · Slatington, PAThe pilot's inadequate compensation for wind conditions and failure to maintain alignment with the runway. The crosswind was a factor.NTSB BFO94LA046Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Berlin, NJThe pilot not maintaining clearance from obstacles (trees) during final approach which resulted in a collision with a tree and a subsequent uncontrolled descent until colliding with the ground.NTSB LAX94LA131Accident · No injuriesLimited investigationFinal reportPiper J5A-L4F · Kernville, CAthe pilot's improper use of the flight controls resulting in his failure to maintain directional control. The existing crosswind is a factor in this accident.NTSB LAX94LA129Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-350 · Phoenix, AZThe loose main fuel line 'b' nut due to the improper installation of the right engine by company maintenance personnel.NTSB LAX94FA130Accident · 3 fatalField investigationFinal reportSikorsky S-58T · Walnut Creek, CAInadequate fuel quality control procedures by the helicopter operator resulting in fuel contamination and a loss of engine power. The pilot's decision to extend the autorotative glide to avoid striking residential homes, which resulted in low main rotor rpm…NTSB CHI94LA090Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Grand Forks, NDFuel starvation due to the improper positioning of the fuel tank selector by the student pilot.NTSB BFO94LA045Accident · Minor injuriesLimited investigationFinal reportPiper PA-31T · Norwood, MAThe pilot's failure to attain alignment with the centerline of the runway, and his failure to execute a missed approach. Factors which contributed to the accident were: the dark night, the pilot's improper decision to initiate the approach in below-minimum…NTSB ATL94LA052Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Kinston, NCA loss of engine power due to a partial blockage of the induction air system by a foreign object (silicon baffling material).NTSB LAX94LA128Accident · 1 fatalLimited investigationFinal reportStinson 108-3 · Redlands, CAThe pilot's impairment of judgment and performance due to alcohol, which led to his improper planning/decision, and his failure to maintain proper altitude. Factors related to the accident were: darkness and the pilot's lack of training/certification for…NTSB CHI94FA089Accident · 5 fatalField investigationFinal reportBeech A36 · Grain Valley, MOThe instrument rated private pilot's inadvertent stall while circling to land. The weather was a factor.NTSB BFO94LA044Accident · No injuriesLimited investigationFinal reportCessna 172 · East Newport, MEImproper engine maintenance by the operator resulting in oil exhaustion and subsequent internal engine damage.NTSB LAX94LA127Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Las Vegas, NVThe cfi's improper remedial action by failing to go-around instead of landing, the cfi's excessive touchdown speed, and his failure to obtain the proper touchdown point. The dual student's initial excessive airspeed and the ditch were factors in this accident.NTSB FTW94LA084Accident · Minor injuriesLimited investigationFinal reportNoble Quickie Q-200 · N. Little Rock, ARThe pilot/owner's inaccurate calculation of the airplane's center of gravity. A factor was the pilot's failure to follow the correct calculation procedure.NTSB CHI94LA092Accident · No injuriesLimited investigationFinal reportCessna 170B · Waupaca, WIThe failure of the pilot to maintain directional control. A factor related to the accident was the gusty crosswind.NTSB BFO94LA048Accident · No injuriesLimited investigationFinal reportJenks Skybolt · Brockport, NYA loss of engine power due to undetermined reason (s). A factor in this accident was the snow covered, rough/uneven terrain which caused the airplane to nose over during landing roll.NTSB BFO94FA043Accident · Serious injuriesField investigationFinal reportBeech C35 · Rockville, MDThe pilot's inadequate aircraft preflight inspection which resulted in a loss of engine power due to fuel contamination.NTSB ATL94LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Smithfield, NCThe pilot's failure to maintain adequate clearance from power lines. Factors were the unmarked power lines located under the final approach path, and the sun glare that existed at the time of the accident.NTSB CHI94LA091Accident · No injuriesLimited investigationFinal reportCessna 150M · La Crosse, WIThe failure of the exhaust valve in the number one cylinder. The lack of suitable terrain for the forced landing was a factor in the accident.NTSB CHI94DCA01Accident · 1 fatalFinal reportPiper PA-39 · Viburnum, MOThe pilot's failure to maintain adequate airspeed during the turn to final. The gusty tailwind during the turn was a contributing factor.NTSB BFO94LA042Accident · No injuriesLimited investigationFinal reportCessna 172M · Ravenna, OHFailure of the pilot to maintain directional control during takeoff leading to a collision with a snow bank which resulted in the airplane nosing over.NTSB BFO94LA041Accident · 1 fatalLimited investigationFinal reportCessna 150 · Lima, OHThe failure of the passenger to maintain clerance from the propeller.NTSB ATL94LA050Accident · Serious injuriesLimited investigationFinal reportArgo Minimax · Franklin, TNThe pilot's failure to secure cargo in the cockpit.NTSB MIA94LA076Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Gulf Of MexicoThe pilot's physiological condition (failure to remain awake) resulting in extended flight over water followed by fuel exhaustion, total loss of engine power, and ditching before returning to land.NTSB LAX94T#A03Accident · No injuriesClass 3Final reportBell 206L-3 · Oro Grande, CANTSB ATL94LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Stockbridge, GAThe partial blockage of the induction air filter because of water soaking, which resulted in a loss of engine power, and the failure of maintenance personnel to properly wash the aircraft.NTSB SEA94LA063Accident · No injuriesLimited investigationFinal reportCessna TU206 · Salt Lake City, UTThe pilot's improper aircraft handling during the aborted takeoff.NTSB SEA94FA062Accident · 1 fatalField investigationFinal reportCessna T210N II · Emmett, IDAn inadvertent stall. Factors contributing to the accident were fuel exhaustion and the tailwind.NTSB MIA94LA075Accident · Minor injuriesLimited investigationFinal reportBeech G18S · Fort Lauderdale, FLThe pilot-in-command's improper approach planning and premature extension of the landing gear, resulting in the flight being unable to maintain sufficient altitude and airspeed to reach the runway. The loss of engine power on one engine was a factor.NTSB MIA94LA074Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Culebra, PRThe failure of the pilot-in-command(CFI) to initiate a go-around after encountering severe turbulence during landing flare and his decision to raise the flaps and reduce engine power to idle after directional control was lost resulting in the aircraft…NTSB LAX94LA143Accident · No injuriesLimited investigationFinal reportAyres S2R · Winterhaven, CAA loss of engine power for an undetermined reason.NTSB FTW94LA083Accident · No injuriesLimited investigationFinal reportCessna 172N · Georgetown, ARA carburetor icing induced power loss due to the pilot's improper use of carburetor heat in conditions conducive to carburetor icing. A factor was the lack of suitable terrain onto which a forced landing could be executed.NTSB LAX94LA126Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Barstow, CAthe pilot's misjudgment of the landing flare altitude during a night autorotation while preoccupied with maintaining proper main rotor rpm. A factor in the accident was the pilot's visual perception which was affected by the outside ambient lighting…NTSB MIA94LA073Accident · No injuriesLimited investigationFinal reportCessna 150L · Ocean Springs, MSThe loss of engine power for undetermined reasons.NTSB MIA94GA072Accident · Minor injuriesFinal reportRobinson R-22B · Pompano Beach, FLFailure of the pilot-in-command to use carburetor heat during a poweroff autorotation, resulting in the engine not responding to throttle input during recovery due to carburetor ice buildup.NTSB CHI94LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Sandwich, ILthe private pilot's failure to maintain directional control of the airplane while landing on a snow and ice covered runway. Factors are the snow on the runway and the snowbank.NTSB BFO94LA040Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Farmville, VAthe pilot's failure to refuel the helicopter with the correct fuel. Factors in the accident were the unclear information given by the passenger and airport line service personnel, the insufficient information regarding the labeling of the airport's fuel…NTSB LAX94LA124Accident · No injuriesLimited investigationFinal reportSchweizer 2-33-A · Dillingham, HIthe pilot's failure to maintain an adequate airspeed margin while maneuvering in the traffic pattern and his inadvertent entry into a stall/mush condition.NTSB LAX94FA125Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Lake Tahoe, CAThe pilot's impairment of judgment and performance due to drugs, which led to his failure to follow the recommended departure procedure, and his failure to maintain sufficient altitude/clearance from rising mountainous terrain. Factors related to the accident…NTSB CHI94LA087Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Grand Forks, NDthe improper maintenance installation (cotter pin) by other maintenance personnel. Factors were main landing gear scissors not safetied properly and extension of landing gear not possible by pilot-in-command (CFI).NTSB CHI94LA086Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Dowagiac, MIFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. Factors related to the accident were: the pilot's lack of experience in this make and model of aircraft, the crosswind, and snow beside the runway.NTSB CHI94LA084Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Eden Prairie, MNThe pilot's poorly planned approach and remaining below a proper glide path during final approach. The pilot's lack of total expereince was a factor.