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 WPR22LA185Accident · No injuriesClass 4 · LimitedFinal reportFrazier Robert L RV-6A · Prineville, ORThe pilot’s improper landing flare which resulted in a bounced landing and loss of directional control.NTSB GAA22WA274AccidentClass 5 · ForeignBeech 90 · Le Bourget, FranceNTSB GAA22WA189Incident · No injuriesClass 5 · ForeignCessna 560 · Schwäbisch Hall, GermanyNTSB GAA22WA187Accident · 2 fatalClass 5 · ForeignSmith Aerostar 601P · Ceballos, MexicoNTSB ERA22LA250Accident · No injuriesClass 4 · LimitedFinal reportCessna 340 · St. Petersburg-Clearwater, FLThe pilot’s inability to stop the airplane on the available runway, which resulted in a runway excursion and collision with an airport perimeter fence.NTSB ERA22LA236Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Nashua, NHThe flight instructor’s failure to maintain control of the helicopter during the takeoff, which resulted in a dynamic rollover.NTSB ERA22LA235Accident · No injuriesClass 3 · LimitedFinal reportCessna 310 · Caryville, FLAn in-flight loss of engine power on both engines for undetermined reasons.NTSB DCA22WA146IncidentClass 5 · ForeignAirbus A320 · Paris, FranceNTSB WPR22LA186Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P172D · Prescott, AZThe loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR22FA184Accident · 1 fatalClass 3 · FieldFinal reportBruce R Prouse M24 Orion Plus · Cape Girardeau, MOThe pilot’s failure to maintain controlled flight, which resulted in a hard left roll, excessive blade flapping and a subsequent in-flight separation of the right horizontal stabilizer.NTSB ERA22LA238Accident · No injuriesClass 4 · LimitedFinal reportMX MXS · Bealeton, VAAn inflight collision with a bird while conducting low level aerobatics.NTSB DCA22LA134Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-700 · Tacoma, WADuring cruise flight with no reported turbulence a passenger sustained a serious injury for an unknown reason.NTSB CEN22LA213Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1 · Marion, TXThe pilot’s loss of control during landing.NTSB CEN22FA208Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Broomfield, COThe pilot’s failure to abort the takeoff due to degraded engine performance. Contributing to the accident was the reduced performance of the engine, the reason for which could not be determined.NTSB ANC22LA055Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182C · Port Moller, AKThe pilot’s inadequate preflight inspection, which did not detect a screw in the control yoke column, and his failure to confirm flight control continuity before takeoff.NTSB WPR21LA368Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Sacramento, CAThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA22WA298Accident · 5 fatalClass 5 · ForeignRobin D140 · Grenoble, FranceNTSB ERA22LA241Accident · No injuriesClass 3 · LimitedFinal reportEvektor-Aerotechnik Sportstar · Lancaster, OHThe improper installation and subsequent failure of the pushrod O-rings, which resulted in failure of the No. 4 connecting rod due to oil starvation.NTSB ERA22LA240Accident · Minor injuriesClass 4 · LimitedFinal reportNew Glasair Glastar · Beckley, WVThe pilot’s failure to maintain control of the airplane while landing in gusting wind conditions.NTSB CEN22LA209Accident · No injuriesClass 3 · LimitedFinal reportTextron B300C · Fort Stockton, TXThe pilot’s failure to maintain directional control while landing with a single engine and maximum braking effort.NTSB ANC22LA034Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Big Lake, AKThe pilot's failure to maintain adequate airspeed during final approach which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall at too low of an altitude to recover.NTSB GAA22WA200Accident · 1 fatalClass 5 · ForeignCessna TU206 · Macizo Del AuyáN-Tepui, VenezuelaNTSB ERA22FA233Accident · 1 fatalClass 3 · FieldFinal reportCessna 140 · Wayne, NEThe pilot’s exceedance of the airplane’s critical angle of attack on final approach while conducting traditional short takeoff and landing operations in gusting wind conditions, which resulted in an aerodynamic stall and spin from which the pilot could not…NTSB WPR22LA182Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Helicopters AS 350B3 · Christmas Valley, ORThe pilot’s inability to maintain control in high wind conditions while repositioning during a landing attempt, which resulted in a loss of control and collision with terrain.NTSB ERA22LA231Accident · No injuriesClass 4 · LimitedFinal reportEurocopter AS355 · Palm Beach, FLThe pilot’s inadequate preflight inspection, which resulted in the unlatched engine cowling opening and being struck by a main rotor blade during flight. Contributing to the accident was the mechanic’s failure to properly secure the cowling following…NTSB CEN22LA207Accident · No injuriesClass 4 · LimitedFinal reportBellanca Cruisemaster · Gainesville, TXThe pilot’s failure to extend the landing gear before landing due to his distraction with the wind gusts.NTSB CEN22LA206Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28R-180 · Beach City, TXThe pilot’s failure to maintain directional control in a gusting quartering tailwind that resulted in a loss of control and impact with trees.NTSB CEN22LA205Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Auburn, INThe student pilot’s improper landing flare and the flight instructor’s delayed remedial response which resulted in an aerodynamic stall.NTSB GAA22WA190Accident · 2 fatalClass 5 · ForeignPiper PA25 · Brasilandia De Minas, BrazilNTSB GAA22WA184AccidentClass 5 · ForeignRans S6-ES · Hampshire, United KingdomNTSB GAA22WA181Accident · 4 fatalClass 5 · ForeignCessna 182 · Piracuara, ColombiaNTSB CEN22LA204Accident · No injuriesClass 3 · LimitedFinal reportCessna T210N · Denver, COThe main landing gear collapsed during landing for reasons that could not be determined.NTSB CEN22FA203Accident · 1 fatalClass 3 · FieldFinal reportAmerican AA-1A · Cleburne, TXThe student pilot’s decision to operate the airplane after consuming alcohol, which led to an exceedance of the airplane’s critical angle of attack, an aerodynamic stall, and a subsequent loss of control at a low altitude.NTSB ANC22LA033Accident · Minor injuriesClass 4 · LimitedFinal reportTaylorcraft F19 · Anchorage, AKA loss of engine power for reasons that could not be determined due to a lack of available evidence.NTSB WPR22LA187Accident · Minor injuriesClass 4 · LimitedFinal reportTwenty Second Street Backcountry Boss · Douglas, WYThe pilot’s inadequate flare and subsequent loss of airplane control during landing.NTSB GAA22WA185Accident · 1 fatalClass 5 · ForeignSikorsky S61N · Tongyeong-si, KiribatiNTSB GAA22WA182Accident · Serious injuriesClass 5 · ForeignRobinson R44 · Lost City, AustraliaNTSB CEN22LA210Accident · No injuriesClass 4 · LimitedFinal reportErcoupe 415-C · Angola, INThe pilot’s failure to maintain control of the airplane while landing in gusting wind conditions, which resulted in a hard landing and the nose landing gear collapse.NTSB ERA22FA227Accident · 1 fatalClass 3 · FieldFinal reportSchweizer SGS 2-33A · Blairstown, NJThe student pilot’s failure to maintain proper alignment with the landing area during the approach, which resulted in the left wing impacting a tree.NTSB CEN22LA202Accident · No injuriesClass 3 · LimitedFinal reportCessna 421C · Monroe, LAThe failure of the maintenance personnel to properly reinstall the elevator trim tab hardware, which resulted in an in-flight separation of the elevator.NTSB WPR22LA183AccidentClass 4 · LimitedFinal reportPyka Pelican · Winters, CADelamination of the uncrewed aircraft systems’ right wing skin surfaces from the wing spar that resulted in a spin and impact with terrain.NTSB WPR22LA179Accident · No injuriesClass 4 · LimitedFinal reportSparks Ralph A RV8 · Deming, NMThe pilot’s loss of airplane control during takeoff following an encounter with a gust of wind.NTSB WPR22LA178Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Estancia, NMThe pilot’s decision to land on an unsuitable surface which resulted in his loss of aircraft control.NTSB WPR22LA177Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-12 · Enterprise, ORThe inadequate maintenance and inspection of the crankshaft expansion plug, which resulted in the separation of the expansion plug from the crankshaft and the subsequent loss of oil and windshield obstruction during departure.NTSB ERA22LA230Accident · No injuriesClass 4 · LimitedFinal reportBeech C24 · Gallatin, TNA landing gear collapse due to the failure and/or separation of the pin in the right main landing gear.NTSB ERA22LA229Accident · No injuriesClass 3 · LimitedFinal reportMesserschmitt-Bolkow-Blohm BK 117 B-2 · Rochester, NYAn unintentional movement of the cyclic control before takeoff, which resulted the main rotor blades contacting the fixed wire cutter.NTSB ERA22LA228Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Lancaster, NYThe student pilot’s excessive pitch during takeoff resulted in a loss of control and impact with terrain. Contributing was the student’s failure to relinquish the controls when ordered by the instructor.NTSB ERA22FA226Accident · 1 fatalClass 3 · FieldFinal reportCessna 172H · Miami, FLA total loss of engine power due to carburetor ice as a result of the pilot’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice.NTSB ERA22LA225Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182 · Owensboro, KYThe pilot's failure to maintain directional control during takeoff.NTSB CEN22LA201Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver Sport 2S · Osawatomie, KSThe loss of engine power due to fuel exhaustion and the pilot’s failure to maintain control of the airplane during a forced landing which resulted in an aerodynamic stall.