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 FTW04CA224Accident · Minor injuriesData collectionFinal reportCessna 172S · Leakey, TXThe pilot's failure to maintain clearance with terrain. A contributing factor was the high density altitude.NTSB CHI04LA243Accident · 1 fatalLimited investigationFinal reportBoeing A75 · Wisconsin Rapid, WIThe pilot's improper in-flight decision when he decided to fly at a low altitude over the river and failed to maintain clearance from the power lines. A factor was the wires.NTSB ATL04CA170Accident · Minor injuriesData collectionFinal reportCessna 172R · Atlanta, GAThe intentional interuption of the flight controls in flight that resulted in a uncontrolled descent and collision with a fence.NTSB ANC04LA098Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-3 · McGrath, AKThe pilot's inadequate in-flight planning/decision making, his continued VFR flight into instrument meteorological conditions, and his failure to maintain obstacle clearance. Factors contributing to the accident were low ceilings due to smoke, rain, and mist.NTSB SEA04IA175Incident · No injuriesIncident investigationFinal reportBoeing 757-200 · Richmond, BC, CanadaThe slat was impacted by birds after takeoff and subsequently the slat delaminated due to flight loads.NTSB SEA04CA174Accident · No injuriesData collectionFinal reportLuscombe 8A · Nampa, IDThe pilot's failure to maintain directional control during the landing roll. Factors include the pilot's very low total time in this make and model aircraft (one hour), and the soft terrain the aircraft encountered along the side of the runway.NTSB FTW04LA222Accident · No injuriesLimited investigationFinal reportLancair 320 · Houston, TXThe pilot's premature lift-off before attaining adequate airspeed resulting in a stall and collision with the ground.NTSB ATL04LA171Accident · Minor injuriesLimited investigationFinal reportHawkins William Searey · Dayton, TNThe delamination of the fiberglass hull of the airplane.NTSB WAS04WA012Accident · 2 fatalForeign investigationSikorsky S-64E · Bastia, Corsica, FranceNTSB SEA04LA176Accident · No injuriesLimited investigationFinal reportCessna 150K · Richland, WAThe pilot's failure to maintain aircraft control during landing. Wind gusts, inadequate compensation for wind conditions, and an airport marker sign were factors.NTSB MIA04WA125Accident · 3 fatalForeign investigationCessna 206 · Nirgua, VenezuelaNTSB FTW04LA223Accident · No injuriesLimited investigationFinal reportCessna 340 · Odessa, TXThe pilot's failure to extend the landing gear prior to landing and the instructor's inadequate supervision.NTSB ANC04LA097Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Kodiak, AKThe pilot's failure to abort the takeoff, which resulted in a collision with a river bank during the takeoff run.NTSB ANC04LA096Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Paxson, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a collision with a rock and subsequent main landing gear collapse during the landing roll. A factor contributing to the accident was rough, uneven terrain.NTSB MIA04LA124Accident · No injuriesLimited investigationFinal reportCessna 550 · Venice, FLThe pilot's failure to maintain adequate airspeed which resulted in a stall and undershoot of the runway.NTSB IAD04CA045Accident · Serious injuriesData collectionFinal reportCameron Balloons Z-90 · Dover, PAThe pilot's failure to arrest an excessive descent rate prior to ground contact, which resulted in a hard landing. A factor was the relatively high winds (for balloon flight.)NTSB MIA04LA123Accident · No injuriesLimited investigationFinal reportBell 206B3 · Panama City, FLInadequate maintenance inspection resulting in the partial loss of engine power due to a loose pneumatic line on the governor and ditching of the helicopter.NTSB MIA04LA122Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · West Palm Beach, FLThe partial loss of engine power due to low cylinder compression during recovery from a practice autorotation resulting in a hard landing and damage to the helicopter.NTSB FTW04LA221Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Shreveport, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA220Accident · Minor injuriesLimited investigationFinal reportBell 212 · Umpire, ARThe pilot's encounter with settling with power resulting in a loss of control. A contributing factor was the high density altitude.NTSB DEN04CA131Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Logan, UTthe instructor's failure to maintain adequate rotor speed during the landing flare, resulting in a hard landing. Contributing factors include the student's delay in relinquishing the controls and the instructor's improper supervision.NTSB DCA04WA077Incident · No injuriesForeign investigationMcDonnell Douglas MD-82 · Taipei, TaiwanNTSB SEA04CA171Accident · Minor injuriesData collectionFinal reportCessna 182P · Hillsboro, ORThe pilot's failure to maintain aircraft directional control during landing roll. A contributing factor was the right-quartering tail wind.NTSB NYC04LA195Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Pittsfield, PAImproper installation of the tailwheel assembly and the inadequate annual inspection which resulted in a loss of directional control during landing.NTSB LAX04FA301Accident · 3 fatalField investigationFinal reportBellanca 7ECA · Malibu, CAThe failure of both pilots to maintain an adequate visual lookout and their failure to see and avoid the other aircraft.NTSB DEN04LA130Accident · Serious injuriesLimited investigationFinal reportBell 206B3 · Atlantic City, WYthe pilot's inability to maintain aircraft control, improper in-flight planning and decision making, and failure to compensate for wind conditions, resulting in collision with terrain. Contributing factors were the intentional low-level maneuver, and the wind…NTSB CHI04WA235Accident · 2 fatalForeign investigationChampion 7ECA · Angle Inlet, MNNTSB CHI04CA237Accident · Serious injuriesData collectionFinal reportEnstrom F-28A · Leroy, MNThe partial loss of engine power due to the missing 1/8-27 NPT Allen plug as a result of other maintenance personnel undertorquing the plug. Additionally, the pilot improperly excecuted a run on landing. A factor was the loss of tail rotor effectiveness.NTSB CHI04CA236Accident · No injuriesData collectionFinal reportCessna 182 · Crystal Lake, ILEngine failure due to fuel exhaustion as a result of the pilot's failure to secure the left wing fuel cap during preflight. A factor was the trees.NTSB ANC04CA094Accident · No injuriesData collectionFinal reportCessna 170B · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll due to the restricted movement of the rudder pedals from his headset cord, which resulted in the airplane exiting the runway and nosing down.NTSB SEA04MA167Accident · 5 fatalMajor investigationFinal reportBell 407 · Battle Mountain, NVThe pilot's failure to maintain clearance from mountainous terrain. Contributing factors were the pilot's improper decision to take the direct route over mountainous terrain, the dark night conditions, and the pressure to complete the mission induced by the…NTSB NYC04CA196Accident · No injuriesData collectionFinal reportWahl S-51D · Louisville, KYThe pilot's failure to maintain directional control on the runway during landing.NTSB LAX04LA325Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Auburn, CAa collapse of the landing gear for undetermined reasons.NTSB IAD04LA043Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T1-A2 · Elkton, KYThe pilot's misidentification of the runway, which resulted in the airplane striking an obscured runway marker. Factors were the tailwheel airplane's reduced forward and lateral visibility during landing rollout and inadequate maintenance of the airport…NTSB FTW04TA219Accident · Serious injuriesFinal reportCessna 182Q · Lamar, OKThe pilot's failure to maintain airspeed which resulted in a inadvertent stall. Contributing factors were the low altitude and high wind.NTSB DEN04LA129Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Sterling, COthe failure of the landing gear extension system for undetermined reasons.NTSB CHI04FA234Accident · 2 fatalField investigationFinal reportCessna 172E · Decorah, IAThe pilot's intentional operation of the airplane with a defective magneto, his failure to abort the takeoff due to degraded aircraft performance, and his failure to obtain or maintain airspeed which resulted in a stall/spin and subsequent impact with the…NTSB CHI04CA240Accident · No injuriesData collectionFinal reportStinson V77 · Howell, MIThe pilot's failure to maintain directional control which resulted in a ground loop. A factor was the pilot's lack of familiarity with the airplane.NTSB CHI04CA239Accident · No injuriesData collectionFinal reportCessna 150H · Golden, MOThe pilot's misjudgment of speed and distance. A factor was the tires positioned at the end of the runway.NTSB ATL04CA169Accident · No injuriesData collectionFinal reportAeronca 7AC · Spring Hope, NCThe binding of the right aileron control cable, which resulted in a loss in aileron control, and subsequent collision with trees and terrain.NTSB SEA04LA172Accident · No injuriesLimited investigationFinal reportTubbs PA-18-225 DD · Salmon, IDDirectional control not maintained during the takeoff roll resulting in a runway excursion and subsequent nose over. Factors include a drainage ditch.NTSB SEA04FA169Accident · 1 fatalField investigationFinal reportCessna A185F · Toutle, WAThe pilot's continued flight into known adverse weather conditions. Inadequate preflight planning/preparation, trees, a low ceiling and no suitable terrain available for the landing were factors.NTSB LAX04LA299Accident · No injuriesLimited investigationFinal reportCessna 182G · Big Bear City, CAthe pilot's mistaken selection of an airport road as the landing runway. Factors in the accident were the nonstandard markings on the temporary landing surface and the glare from the setting sun.NTSB LAX04FA300Accident · 2 fatalField investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Oroville, CAthe pilot's failure to maintain clearance from the water's surface, which resulted in his dragging of the right wing pontoon during low-altitude flight. The glassy-surfaced water was a contributing factor to the accident.NTSB CHI04LA245Accident · Serious injuriesLimited investigationFinal reportFall Cub · Rockville, INThe fuel starvation encountered due to the builder's inadequate fuel system design and the subsequent loss of engine power during a maneuver for the landing approach. Factors were the tree and corn.NTSB LAX04CA298Accident · No injuriesData collectionFinal reportBerry Hatz CB-1 · Upland, CAthe pilot's inadequate recovery following a bounced landing, improper use of the rudder control, and failure to maintain directional control.NTSB IAD04LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · London, KYAn undocumented, improper repair attempt, which subsequently resulted in fatigue cracking to the rib cap.NTSB IAD04FA040Accident · 1 fatalField investigationFinal reportPiper PA-31P · Clarkson, NYThe pilot's mismanagement of the fuel by his failure to select the proper fuel tank which resulted in starvation and subsequent loss of engine power in both engines.NTSB FTW04CA218Accident · No injuriesData collectionFinal reportBeech BE-58 · Groveton, TXThe pilot's intentional ground loop to avoid colliding with deer that entered the runway during the landing roll. A contributing factor was the tall grass adjacent to the runway that prevented detection of the deer.NTSB DEN04LA128Accident · Minor injuriesLimited investigationFinal reportBeech 95-B55 · Roosevelt, UTthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for a forced landing.