NTSB investigations
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 CEN21FA199Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Port Aransas, TXThe pilot’s failure to maintain adequate airspeed during the go-around, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall.NTSB WPR21FA175Accident · 2 fatalClass 3 · FieldFinal reportSwearingen SA226-T(B) · Winslow, AZThe loss of engine power to the right engine for reasons that could not be determined. Contributing to the accident was the pilot’s failure to maintain control of the airplane.NTSB GAA21WA088Accident · 1 fatalClass 5 · ForeignAgusta A119 · Nuevo Laredo, MexicoNTSB ERA21LA191Accident · 1 fatalClass 3 · LimitedFinal reportRobinson Helicopter R44 · Forkston, PAThe pilot’s inadequate preflight weather planning, which resulted in an inadvertent encounter with instrument meteorological conditions at night, spatial disorientation, and collision with terrain.NTSB CEN21LA196Accident · No injuriesClass 4 · LimitedFinal reportMobi-light CCX-2300 · Loveland, COThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop, and the failure of both pilots to establish who was in control of the airplane.NTSB CEN21FA198Accident · 4 fatalClass 3 · FieldFinal reportPiper PA-46-310P · Danville, ARThe pilot’s improper decision to continue flight in an area of moderate-to-heavy icing conditions, which resulted in exceedance of the airplane’s anti-icing system capabilities, a degradation of aircraft performance, and subsequent aerodynamic stall.NTSB WPR21LA173Accident · Minor injuriesClass 3 · LimitedFinal reportFlight Design Ctsw · Santa Fe, NMA leak in the oil line that supplied the engine with oil, which resulted in oil exhaustion and the total loss of engine power. Contributing to the accident was the routing of the oil line to close to the exhaust manifold.NTSB WPR21LA172Accident · No injuriesClass 4 · LimitedFinal reportMichael J Robbins Searey · Friday Harbor, WAPartial loss of engine power due to the detachment of the throttle cable from the carburetor arm, as a result of the pilot’s inadequate maintenance which resulted in an off-airport landing and impact with vegetation.NTSB GAA21WA119Accident · No injuriesClass 5 · ForeignSpitfire MK26 · Breighton, UK, United KingdomNTSB GAA21WA089Accident · 1 fatalClass 5 · ForeignVans RV7A · Columbia, AustraliaNTSB ERA21LA395Accident · Serious injuriesClass 4 · LimitedFinal reportSchempp Hirth Ventus C · Wagener, SCImpact with trees during a forced landing in atmospheric lift conditions that were insufficient to maintain flight. Contributing was the pilot’s delayed decision to return to the airport.NTSB ERA21LA197Accident · No injuriesClass 4 · LimitedFinal reportCessna 402C · New Bedford, MAAn inadvertent collision with a bird during descent, resulting in substantial damage to the vertical stabilizer.NTSB CEN21LA197Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Faribault, MNThe student pilot’s failure to maintain control during takeoff in gusty wind conditions and the flight instructor’s delayed remedial action, which resulted in the airplane colliding with trees and subsequently the ground.NTSB WPR21LA171Accident · Minor injuriesClass 3 · LimitedFinal reportConsolidated Aeronautics Lake LA-4-200 · Twentynine Palms, CAA partial loss of engine power due to inadequate ignition from cracked spark plugs and a failed magneto.NTSB WPR21FA170Accident · 1 fatalClass 3 · FieldFinal reportConsolidated Vultee BT-13A · Camas, WAThe pilot’s exceedance of the airplane’s critical angle of attack during an aborted landing, resulting in an aerodynamic stall and impact with terrain.NTSB GAA21WA086Accident · 1 fatalClass 5 · ForeignSikorsky S76C+ · Oak Cheon Goon, South KoreaNTSB ERA21FA189Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28RT-201T · Brownsville, TNThe student pilot’s continued visual flight rules flight into night instrument meteorological conditions, which resulted in spatial disorientation and a rapid uncontrolled descent into terrain. Contributing to the accident were the self-induced and external…NTSB ANC21LA032Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Tyonek, AKThe pilot’s loss of directional control while dragging the surface of an ice- and snow-covered lake in gusting wind conditions, which resulted in an impact with a tree.NTSB WPR21LA168Accident · No injuriesClass 4 · LimitedFinal reportDavis Donald M Bushby Mustang II · Maricopa, AZThe pilot’s failure to maintain airplane control during takeoff with a quartering right tailwind.NTSB GAA21WA082Accident · 1 fatalClass 5 · ForeignLearjet 35 · Belo Horizonte, BrazilNTSB ERA21LA190Accident · No injuriesClass 3 · LimitedFinal reportCessna 182M · Eufaula, ALA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN21LA210Accident · Serious injuriesClass 4 · LimitedFinal reportFirefly Balloons 2010 Firefly 12B-010 · Pagosa Springs, COThe pilot’s failure to properly control the balloon during a steep approach that resulted in a hard landing and a serious passenger injury.NTSB GAA21WA080Accident · No injuriesClass 5 · ForeignDiamond A20-C1 · Tarragona, SpainNTSB CEN21LA214Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5B · Gonzales, TXThe pilot’s failure to maintain directional control during landing that resulted in a runway excursion and collision with a pole.NTSB CEN21LA206Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Curtis, NEWater contamination of the airplane’s fuel supply which resulted in a total loss of engine power.NTSB CEN21FA195Accident · 1 fatalClass 3 · FieldFinal reportCessna 340A · Tatum, TXThe pilot’s loss of airplane control for undetermined reasons.NTSB WPR21LA163Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Wilsall, MTThe pilot's failure to maintain directional control during the landing roll with a crosswind.NTSB GAA21WA078Accident · No injuriesClass 5 · ForeignLearjet 25 · Toluca de Lerdo, MexicoNTSB CEN21LA193Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28R · McKinney, TXA total loss of engine power for reasons that could not be determined based on the available information.NTSB WPR21LA165Accident · No injuriesClass 4 · LimitedFinal reportBryan S Happell TANGO2 · Hayden, IDThe pilot’s failure to control the pitch attitude of the gyroplane during landing, which resulted in a loss of control, runway excursion and collision with terrain.NTSB WPR21LA162Accident · No injuriesClass 4 · LimitedFinal reportThrush S2R-T660 · Hermiston, ORThe pilot’s loss of directional control due to a blown tire, which resulted in a runway excursion and impact with terrain.NTSB WPR21LA161Accident · 2 fatalClass 3 · LimitedFinal reportRans S12 · Colville, WAThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering to avoid powerlines, which resulted in an aerodynamic stall and a loss of control. Contributing to the accident was the partial loss of engine power due to improper…NTSB GAA21WA076Accident · 1 fatalClass 4 · ForeignPiper PA-31-350 · South Bimini, BahamasNTSB ERA21LA187Accident · No injuriesClass 3 · LimitedFinal reportCessna 172S · Venice, FLA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN21LA194Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · North Vernon, INThe pilot’s improper installation of the fuel selector handle, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN21LA191Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Caro, MIThe pilot's inadequate preflight inspection and fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR21LA166Accident · 2 fatalClass 3 · LimitedFinal reportCessna 140 · Williams, AZThe pilot’s loss of control due to spatial disorientation shortly after takeoff in night visual meteorological conditions.NTSB GAA21WA085Accident · No injuriesClass 5 · ForeignCessna 550 · Eelde, NetherlandsNTSB ERA21LA352Accident · No injuriesClass 4 · LimitedFinal reportHine T L/Johnson R Bush Wacker · Thomaston, GAA loss of directional control upon landing for reasons that could not be determined as a result of a delayed report. Contributing was the pilot’s decision to continue a flight with an unknown airworthiness issue.NTSB ANC21LA030Accident · No injuriesClass 4 · LimitedFinal reportBeech C-99 · Chignik Lagoon, AKThe pilot’s failure to visually inspect the runway condition before landing, which resulted in a collision with an ice chunk and main landing gear separation during landing.NTSB WPR21LA176Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV4 · Oljato-Monument Valley, UTThe pilot’s failure to maintain airplane control while compensating for a downdraft during landing, which resulted in the airplane touching down short of the runway on soft terrain and nosing over.NTSB WPR21LA160Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Cottonwood, AZThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB WPR21LA159Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Pullman, WAThe pilot's failure to maintain directional control during taxiing in crosswind conditions, which resulted in the airplane nosing over.NTSB GAA21WA105Accident · No injuriesClass 5 · ForeignBeech D17 · Leer (Ostfriesland), GermanyNTSB GAA21WA074Accident · No injuriesClass 5 · ForeignPiper J3 · Epse, NetherlandsNTSB ERA21LA188Accident · No injuriesClass 3 · LimitedFinal reportCessna A188 · Dover, NCA total loss of engine power due to a shift of a crankshaft main bearing, which resulted in a lack of lubrication and subsequent overheating and failure of the engine crankshaft. Contributing to the accident was the hard touchdown during the forced landing.NTSB CEN21LA190Accident · No injuriesClass 3 · LimitedFinal reportGates Learjet 35A · Colorado Springs, COThe flight crew’s improper decision to continue the unstabilized approach, which resulted in an aerodynamic stall and impact with the runway during landing.NTSB ANC21LA031Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Anchorage, AKA loss of control during landing for reasons that could not be determined based on the available evidence.NTSB WPR21LA157Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Bellingham, WAThe student pilot’s inadequate flare resulting in a loss of control during landing with a crosswind and subsequent nose over.NTSB GAA21WA081Accident · 2 fatalClass 5 · ForeignCessna 172 · Canberra, Australia