NTSB investigations
19,222 cases where NTSB found Aircraft.
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 WHERE c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01')) 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 WHERE c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01')) 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 GAA19CA570Accident · Serious injuriesData collectionFinal reportCirrus SR22 · Lexington, NEThe pilot's exceedance of the airplane's critical angle of attack during a go around, which resulted in an aerodynamic stall and a hard landing.NTSB CEN19TA333Accident · No injuriesClass 3Final reportLancair Lancair 320 · Bolivar, MOInadequate maintenance of the airplane, which resulted in a lack of adequate hydraulic fluid, malfunction of the landing gear extension system, and the landing gear collapse on landing.NTSB WPR19LA265Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35 · Gresham, ORA total loss of engine power due to fuel starvation as a result of the instructor’s inadequate in-flight fuel management.NTSB GAA19CA591Accident · Serious injuriesData collectionFinal reportCessna 182 · Elizabethtown, NCThe pilot's improper landing flare, which resulted in a hard landing and postaccident fire. Contributing to the accident was the pilot’s distraction during short final.NTSB ERA19LA282Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 337 · St. Augustine, FLThe failure of the pilot and examiner to recognize that the rear engine was not developing power, which resulted in an attempted partial-power takeoff and the airplane’s subsequent descent and impact with terrain.NTSB ERA19LA280Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Manville, NJA total loss of engine power due to the ingestion of sealant material that had loosened inside the carburetor airbox.NTSB CEN19FA332Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Prairie Grove, ARThe noninstrument-rated pilot's loss of control due to spatial disorientation after encountering instrument meteorological conditions at night.NTSB GAA19CA580Accident · No injuriesData collectionFinal reportCessna 172 · Plant City, FLThe student pilot's failure to maintain directional control during the aborted landing, which resulted in a runway excursion and impact with a ditch.NTSB GAA19CA572Accident · No injuriesData collectionFinal reportPiper PA18 · Boulder, COThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB GAA19CA567Accident · No injuriesData collectionFinal reportGeorge W. Felix Mosquito · Kershaw, SCThe pilot's improper cyclic input during takeoff, which resulted in a loss of helicopter control, the skid impacting the ground, and a subsequent dynamic rollover.NTSB GAA19CA560Accident · No injuriesData collectionFinal reportThomas Lee Nieuport 11 · Rose Hill, KSThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and an impact with runway lights.NTSB ERA19TA277Accident · Serious injuriesClass 3Final reportVans RV 6 · Lakeland, FLThe pilot’s inability to maintain control due to passenger interference.NTSB ANC19LA054Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 18 · Beluga, AKThe pilot’s decision to perform a takeoff with an overweight float-equipped airplane, which resulted in diminished climb performance.NTSB GAA19CA563Accident · No injuriesData collectionFinal reportDe Havilland Beaver DHC 2 · Mountain Village, AKThe pilot's improper takeoff configuration due to distraction, which resulted in the airplane’s failure to become airborne and its subsequent collision with rising terrain. Contributing to the accident was the pilot's failure to use the Before Takeoff…NTSB CEN19LA326Accident · No injuriesClass 3 · LimitedFinal reportVans Vans RV-10 · Lancaster, TXA partial loss of engine power due to a faulty magneto/ignition system, which resulting in a forced landing.NTSB CEN19FA325Accident · 2 fatalClass 3 · FieldFinal reportCessna A185 · Conroe, TXA partial loss of engine power due to fuel contamination with water, and the pilot’s failure to maintain control of the airplane during an attempted return to the airport shortly after takeoff, which resulted in an aerodynamic stall.NTSB GAA19CA569Accident · No injuriesData collectionFinal reportDiamond DA20 · Fort Wayne, INThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion, a total loss of engine power, and impact with a tree during an off-airport landing.NTSB GAA19CA559Accident · No injuriesData collectionFinal reportPiper PA60 · Sedona, AZThe pilot's exceedance of the airplane's critical angle of attack during landing in gusting crosswind conditions, which resulted in an aerodynamic stall.NTSB ERA19TA278Accident · No injuriesClass 3Final reportCessna 208 · Pepperell, MAThe pilot's loss of control when the airplane encountered a downdraft during landing approach, which resulted in a subsequent hard landing and gear collapse.NTSB WPR19FA262Accident · 1 fatalClass 3 · FieldFinal reportCessna 177 · Torrance, CAThe pilot’s failure to maintain adequate airspeed and exceedance of the aircraft's critical angle of attack while turning during climb out, which resulted in an aerodynamic stall.NTSB GAA19CA566Accident · No injuriesData collectionFinal reportCessna 152 · Denton, TXThe student pilot's improper landing flare, which resulted in a hard, bounced landing and a nose landing gear collapse.NTSB CEN19TA335Accident · Minor injuriesClass 3Final reportVans RV 4 · De Soto, MSA total loss of engine power due to fuel exhaustion.NTSB CEN19FA323Accident · 1 fatalClass 3 · FieldFinal reportBeech V35 · London, OHThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering toward the final leg of the traffic pattern and facing the rising sun, which resulted in a subsequent aerodynamic stall at too low an altitude to recover.NTSB GAA19CA584Accident · No injuriesData collectionFinal reportPiper PA18 · New Meadows, IDThe pilot receiving instruction's failure to maintain directional control during takeoff with a gusting, right quartering headwind, which resulted in a noseover.NTSB GAA19CA556Accident · No injuriesData collectionFinal reportCessna 152 · Naples, FLThe student pilot's improper landing flare, which resulted in a porpoised landing and a nose landing gear collapse.NTSB GAA19CA552Accident · No injuriesData collectionFinal reportMaule M 6-235 · Palmer, AKThe pilot's selection of unsuitable terrain for landing and his failure to maintain directional control during the landing, which resulted in the airplane hitting a rut, bouncing, and then nosing over.NTSB ERA19LA274Accident · Minor injuriesClass 3 · LimitedFinal reportSocata TB9 · Fort Meade, MDThe failure of the carburetor intake scat tubing, which resulted in a partial loss of engine power.NTSB ERA19LA273Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R44 · Sardis, GAFatigue failure of the fasteners on the engine crankshaft, which resulted in a partial loss of engine power and a subsequent forced landing.NTSB ERA19FA275Accident · 2 fatalClass 3 · FieldFinal reportVans RV 8 · Stroudsburg, PAThe pilot's failure to maintain control of the airplane for undetermined reasons.NTSB GAA19CA554Accident · No injuriesData collectionFinal reportPiper PA32R · Owasso, OKThe pilot's improper altitude and airspeed control during landing, which resulted in the airplane landing long and a subsequent runway overrun and impact with a drainage culvert.NTSB GAA19CA550Accident · No injuriesData collectionFinal reportPzl Okecie PZL104 · Reno, NVThe pilot's failure to maintain bank control during takeoff in gusting crosswind conditions, resulting in a loss of control in flight and subsequent impact with terrain.NTSB ENG19IA034Incident · No injuriesClass 3 · IncidentFinal reportAirbus A220 · Côte-d'Or Region, FranceA No. 1 (left) engine low pressure compressor (LPC) stage 1 integrally bladed rotor (IBR) separation due to a high cycle fatigue crack (HCF) that originated at the runout of an airfoil leading edge root radius. The HCF crack developed because of a…NTSB GAA19CA555Accident · Serious injuriesData collectionFinal reportCessna 175 · Toklat, AKThe pilot's loss of airplane control and his subsequent exceedance of the airplane's critical angle of attack during takeoff in variable, gusting wind conditions, which resulted in an aerodynamic stall.NTSB GAA19CA551Accident · No injuriesData collectionFinal reportPiper PA 12 · Healy, AKThe pilot's exceedance of the airplane's critical angle of attack while taking off from water in shifting wind conditions.NTSB GAA19CA549Accident · No injuriesData collectionFinal reportCessna L19 · Kennett, MOThe pilot's failure to install the engine oil filler cap before the first flight of the day; his subsequent failure to conduct a preflight check before the accident flight, which resulted in his failure to note that the cap was not installed; and his improper…NTSB ERA19LA272Accident · Minor injuriesClass 3 · LimitedFinal reportDiamond DA40 · Norfolk, VAA partial loss of engine power due to the mechanic's failure to properly tighten the two clamps securing the flexible coupling from the intercooler to the induction inlet.NTSB WPR19LA273Accident · No injuriesClass 3 · LimitedFinal reportSmyth Sidewinder · Tucumcari, NMThe in-flight separation of a section of a propeller blade due to a fatigue crack, which resulted in a forced landing.NTSB WPR19LA259Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Marana, AZExcessive fuel pressure and temperature throughout the fuel system due to heat soaking, which resulted in an engine fire during engine start.NTSB GAA19CA546Accident · No injuriesData collectionFinal reportMooney M20M · Chandler, AZThe pilot's improper pitch control during takeoff and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the flight instructor's failure to take remedial action.NTSB CEN19LA331Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR20 · Orange, TXA total loss of engine power due to a fatigue failure of the fuel line from the fuel manifold to the No. 1 cylinder.NTSB GAA19CA545Accident · No injuriesData collectionFinal reportCessna P206 · Caldwell, IDThe pilot's improper approach, which resulted in a long landing, a runway overrun, and collision with a drainage culvert.NTSB ERA19CA291Accident · No injuriesData collectionFinal reportBeech 55 · Sebring, FLThe passenger’s inadvertent retraction of the landing gear during the landing roll without being instructed to do so by the pilot.NTSB CEN19LA320Accident · Minor injuriesClass 2 · LimitedFinal reportCirrus SR22 · Hoagland, INA catastrophic engine failure and forced landing due to the separation of the No. 1 connecting rod as a result of migration of the connecting rod piston pin bushing. Contributing to the accident was the mechanic’s failure to follow manufacturer guidance…NTSB WPR19LA257Accident · Serious injuriesClass 3 · LimitedFinal reportKubicek BB60 · Goodsprings, NVThe pilot's failure to maintain the proper descent rate during the approach to landing, which resulted in a hard landing and serious injuries to the pilot and two passengers.NTSB GAA19CA543Accident · No injuriesData collectionFinal reportCessna 150 · Memphis, TNThe student pilot's improper landing flare and the flight instructor's delayed remedial action during landing, which resulted in a loss of airplane control and impact with terrain.NTSB GAA19CA542Accident · No injuriesData collectionFinal reportCessna 172 · Phoenix, AZThe student pilot's failure to maintain directional control during an aborted takeoff, which resulted in a runway excursion and impact with runway signs while attempting to maneuver back onto the runway.NTSB ERA19LA279Accident · No injuriesClass 3 · LimitedFinal reportPiper PA23 · Charlotte AmalieThe collapse of the left main landing gear for undetermined reasons.NTSB ERA19LA269Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20J · Bowie, MDA blockage of the pitot static system that preclude the airspeed indicator from displaying speeds greater than 40 mph, which led the pilot to abort the landing and overrun the runway.NTSB CEN19LA318Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Hill City, SDA total loss of engine power for undetermined reasons, which resulted in a hard landing.NTSB CEN19LA316Accident · 1 fatalClass 3 · LimitedFinal reportInfinity Powered Parachutes IPP2 · Eustace, TXThe pilot’s failure to see and avoid a power line. Contributing was the pilot’s decision to fly at an altitude too low to avoid obstacles.