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 ANC07CA030Accident · No injuriesData collectionFinal reportPiper PA-22 · Soldotna, AKThe pilot's failure to compensate for a crosswind during the landing roll, which resulted in a loss of control, an encounter with a muddy berm, and a nose over. A factor in the accident was a crosswind.NTSB NYC07CA103Accident · No injuriesData collectionFinal reportChampion 7ECA · Nashua, NHThe pilot's misjudged altitude while maneuvering for a banner pickup, which resulted in the banner rope becoming entangled in the airplane's landing gear, and a hard landing, during the ensuing emergency off airport landing.NTSB LAX07LA134Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Palo Alto, CAa loss of engine power for undetermined reasons.NTSB CHI07LA115Accident · 2 fatalLimited investigationFinal reportBird Seawind 3000 · Knox City, MOThe loss of engine power for an undetermined reason. Contributing to the accident was the unsuitable terrain that was encountered by the pilot during the forced landing.NTSB CHI07FA114Accident · 2 fatalField investigationFinal reportRobinson Helicopter R44 II · Bass Lake, INThe pilot's failure to maintain a proper approach glidepath, which resulted in a settling-with-power flight condition. Contributing to the accident was the dark night light condition.NTSB NYC07FA100Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Windham, CTThe pilot's failure to maintain control of the airplane during a go-around.NTSB LAX07CA133Accident · No injuriesData collectionFinal reportJiran FJ-1 · Banks, ORthe pilot's misjudged distance/altitude that led to a failure to attain the proper touchdown point.NTSB LAX07CA132Accident · No injuriesData collectionFinal reportCessna U206-C · Cottonwood, IDThe pilot's misjudgment of distance/speed, which resulted in a overshoot of the runway in tailwind conditions and subsequent nose over. Factors in the accident were the tail wind condition and the short runway.NTSB CHI07LA113Accident · 2 fatalLimited investigationFinal reportMurphy Aircraft Mfg SR3500 Moose · Cotter, ARThe pilot not maintaining airplane control and airspeed during the approach. Factors were the gusty wind conditions, the inadvertent stall the pilot encountered, and the power lines that were impacted during the uncontrolled descent.NTSB CHI07CA111Accident · Minor injuriesData collectionFinal reportCessna 150F · Paw Paw, MIThe student pilot's inadequate compensation for wind conditions while on final approach. Contributing factors to the accident were the gusting wind conditions and the trees.NTSB ATL07IA078Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-111 · Atlanta, GAThe mechanics failure to follow procedures and directives in securing the lower engine cowling after maintenance, and the failure of the first officer to follow the checklist to ensure the engine cowling was secured during the walk around inspection resulting…NTSB ATL07FA077Accident · 5 fatalField investigationFinal reportBeech 58 · Hamilton, GAThe pilot's exceeding the design stress limits of the airplane while performing aerobatics in a nonaerobatic airplane, which resulted in an in-flight overload failure of the airframe. A factor in the accident was the pilot's decision to perform aerobatics.NTSB ATL07CA080Accident · No injuriesData collectionFinal reportRans RV-4 · Selma, ALThe pilot's failure to maintain directional control during landing roll.NTSB ATL07CA076Accident · No injuriesData collectionFinal reportBell 206-B · Sevierville, TNThe pilot's improper use of the flight controls while at a hover that resulted in the tail colliding with the ground, a subsequent hard landing, and collapse of the skids.NTSB SEA07LA111Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Van Horn, TXClearance was not maintained after landing by the instructor pilot, which resulted in an on ground collision with the helicopter standing near the refueling pumps. The aircraft standing in the refueling area was a factor.NTSB SEA07LA110Accident · Minor injuriesLimited investigationFinal reportEurocopter EC 130 B4 · Makawao, HIThe pilot's improper decision to takeoff downwind in a confined landing zone, which resulted in a failure to attain translational lift and a loss of control.NTSB NYC07LA102Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Russellville, KYA loss of engine power for undetermined reasons, during the initial climb after an aborted landing.NTSB MIA07LA085Accident · Minor injuriesLimited investigationFinal reportSmith Carter A Wheeler Exp 2000 · Stuart, FLContamination of the fuel system which resulted in a loss of engine power. Contributing to the accident was unsuitable terrain for a forced landing.NTSB MIA07LA084Accident · 5 fatalLimited investigationFinal reportPiper PA-23-250 · Atlantic Ocean (Atlantic Ocean)The pilot's continued visual flight rules flight into known adverse weather conditions, resulting in an in-flight loss of aircraft control. Contributing to the accident were thunderstorms.NTSB MIA07FA083Accident · 3 fatalField investigationFinal reportCessna 182Q · Cudjoe Key, FLThe pilot's failure to maintain clearance from an active restricted area, which resulted in the airplane colliding with the tether of an aerostat.NTSB LAX07CA131Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Spanish Fork, UTThe student pilot's improper use of the flight controls, which induced a dynamic rollover. Also causal was the certificated flight instructor's inadequate supervision and delayed remedial action.NTSB DFW07WA094Accident · 2 fatalForeign investigationBell 206 · Changuinola, PanamaNTSB DCA07WA042Incident · No injuriesForeign investigationSikorsky 76-C+ · North Sea, United KingdomNTSB CHI07CA118Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Williamston, MIThe pilot's improper recovery from a bounced landing which resulted in the collapse of the nose landing gear. The hilly runway was a contributing factor.NTSB CHI07CA117Accident · Minor injuriesData collectionFinal reportNeal Anderson Comp Air 6 · Sturtevant, WIThe pilot's failure to obtain a proper touchdown point, which resulted in a runway over run and subsequent nose-over of the aircraft, and the pilot's improper weather evaluation to land with a quartering tailwind. Factors contributing to the accident were a…NTSB CHI07CA116Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA 20-A1 · Warrenton, MOThe pilot's inadequate pre-flight planning which resulted in exhaustion of the fuel supply and the unsuitable terrain encountered for the forced landing. A factor in the accident was inaccurate fuel quantity indication.NTSB CHI07CA112Accident · No injuriesData collectionFinal reportPZL Warzawa-CNPSL PZL-104 Wilga 35A · Waukesha, WIThe pilot's decision to attempt flight following the initial loss of engine power and successful forced landing to a cornfield. An additional cause was the loss of engine power for undetermined reasons. A contributing factor was the furrowed cornfield…NTSB CHI07CA110Accident · No injuriesData collectionFinal reportEngineering & Research Ercoupe 415-C · Brighton, MIThe student pilot's failure to maintain proper glidepath to the runway. Contributing factors to the accident included the passenger vehicle, the rising embankment, and the airport perimeter fence.NTSB SEA07LA108Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Kahuku, HIFatigue cracking of the oil line from the engine gearbox to the oil pressure gauge, which resulted in loss of engine lubricating oil, leading to seizure of the power turbine.NTSB SEA07CA109Accident · Minor injuriesData collectionFinal reportCessna 172I · Peach Springs, AZThe pilot's failure to adequately compensate for the gusty wind condition encountered on final approach, resulting in a loss of control and an in-flight collision with a dirt berm. A contributing factor was the gusty wind condition.NTSB SEA07CA100Accident · No injuriesData collectionFinal reportCessna 150E · Levelland, TXThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. A factor was the lack of suitable terrain for the forced landing.NTSB NYC07CA101Accident · Minor injuriesData collectionFinal reportStinson 108-3 · Pompton Plains, NJA loss of engine power during the initial climb for undetermined reasons.NTSB CHI07CA119Accident · No injuriesData collectionFinal reportJohnson-Whittman Tailwind JW9L · Saginaw, MIThe pilot's failure to maintain the proper glidepath and clearance from a fence while on final approach.NTSB SEA07CA107Accident · Minor injuriesData collectionFinal reportCessna 172B · Los Angeles, CAThe pilot's failure to maintain adequate airspeed during performance of a go around, resulting in an inadvertent stall and in-flight collision with the ground.NTSB NYC07LA098Accident · 2 fatalLimited investigationFinal reportGrumman American AA-5B · Danville, VAThe passenger's inadvertent interference with the flight controls due to his physiological condition. Contributing to the accident was the pilot's inability to maintain aircraft control.NTSB NYC07CA099Accident · Minor injuriesData collectionFinal reportMonocoupe 90A · Lakeland, FLThe pilot's improper flare and failure to maintain airspeed, which resulted in a stall and subsequent loss of control. A factor was the sun glare.NTSB MIA07LA081Accident · 2 fatalLimited investigationFinal reportCessna U206G · Welaka, FLThe pilot's continued visual flight into instrument meteorological conditions and his failure to maintain clearance from utility poles. Contributing to the accident were the fog and haze.NTSB ENG07WA027Incident · No injuriesForeign investigationBoeing 747-300 · Dammam, Saudi ArabiaNTSB SEA07FA106Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Tehachapi, CAThe pilot's VFR flight into IMC and his ensuing failure to maintain terrain clearance. Contributing factors were the cloudy weather conditions and the mountainous terrain.NTSB SEA07CA105Accident · No injuriesData collectionFinal reportCessna 150E · Shawnee, OKThe pilot's inadequate inflight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. A factor was the tree.NTSB NYC07FA096Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Saranac Lake, NYThe pilot's failure to maintain adequate airspeed during initial climb after takeoff, which resulted in an inadvertent stall.NTSB MIA07WA082Incident · No injuriesForeign investigationBeech 1900D · Marsh Harbour, BahamasNTSB MIA07CA078Accident · Serious injuriesData collectionFinal reportRobert J. Goodyear Hummel Bird · Lakeland, FLThe pilot's failure to maintain airspeed during a go-around.NTSB DEN07WA095Accident · No injuriesForeign investigationSikorsky S61N · Gamle Qutdligss, GreenlandNTSB ANC07LA029Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Anchorage, AKThe improper installation/reversal of the aileron flight control system by other maintenance personnel, and the pilot's inadequate preflight inspection, which resulted in a loss of control during takeoff initial climb.NTSB SEA07CA104Accident · No injuriesData collectionFinal reportMaule MT-7-235 · Concord, CAThe pilot's failure to maintain directional control during landing, resulting in a ground loop/swerve and collapse of the nose landing gear. A contributing factor was the gusty wind condition.NTSB SEA07CA103Accident · Minor injuriesData collectionFinal reportCessna 152 · Oak Glen, CAThe flight instructors failure to maintain clearance from trees while maneuvering. Contributing factors were the downdraft weather condition, and the tree.NTSB SEA07CA102Accident · Minor injuriesData collectionFinal reportNorth American Aviation Div. T-28C · Red Lodge, MTThe lack of suitable terrain for a forced landing. Contributing factors were the loss of engine power during takeoff for undetermined reasons, and rough/uneven condition of the terrain.NTSB NYC07LA095Accident · Serious injuriesLimited investigationFinal reportRolladen-Schneider LS8-18 · Circleville, WVThe glider's inadvertent encounter with mechanical turbulence.NTSB MIA07LA077Accident · 2 fatalLimited investigationFinal reportTerrence A. Sack Terrair Express · Lakeland, FLThe failure of the pilot to maintain airspeed while turning base to final which led to a stall. A contributing factor in the accident was the pilot's lack of recent experience.