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 CEN16LA330Accident · Minor injuriesLimited investigationFinal reportHiller UH 12D · Cokeville, WYFailure of the control rotor cuff due to fatigue.NTSB GAA16CA497Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Brunswick, GAThe total loss of engine power during takeoff due to a loose B-nut on the fuel flow divider input fuel line fitting, which resulted in a fuel leak and fuel starvation.NTSB GAA16CA448Accident · No injuriesData collectionFinal reportCessna 152 · Miami, FLThe pilot's improper pitch control during landing, which resulted in a bounced landing, and a nose landing gear collapse.NTSB GAA16CA446Accident · No injuriesData collectionFinal reportCessna A185 · Caldwell, IDThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a ground loop.NTSB GAA16CA444Accident · Minor injuriesData collectionFinal reportP Z L -Warszawa-Cnpsl PZL 104 Wilga · Austin, NVThe pilot's failure to maintain an appropriate descent rate during the base to final turn, which resulted in a forced landing, and an intentional aerodynamic stall. Contributing to the accident was the pilot's excessive braking, which resulted in a nose over…NTSB GAA16CA438Accident · No injuriesData collectionFinal reportCessna A185 · Fayetteville, TNThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a runway excursion and a ground loop.NTSB GAA16CA442Accident · No injuriesData collectionFinal reportCessna 172 · Anchorage, AKThe facility's designation of the taxiway for use by maintenance personnel to conduct high thrust tests without appropriate safeguards in place, which led to maintenance personnel conducting high-power, run-up thrust procedures across the active taxiway and…NTSB ERA16LA305Accident · No injuriesLimited investigationFinal reportDayton A Babcock Storm · Eustis, FLThe pilot's failure to maintain directional control during an aborted takeoff. Contributing to the accident were the loss of engine power due to a malfunctioning alternator, which precipitated the off-field landing, and the pilot’s decision to attempt to take…NTSB ERA16LA296Accident · No injuriesLimited investigationFinal reportMantell Allan T Kitfox 4 1200 · Canandaigua, NYThe failure of the right rudder pedal torque tube due to fatigue, which resulted in a loss of directional control during landing. Also causal to the accident was the airplane owner/builder's failure to install a rudder torque tube reinforcement or replacement…NTSB GAA16CA443Accident · No injuriesData collectionFinal reportCessna A185 · Klamath Falls, ORThe pilot's improper landing flare, which resulted in the airplane porpoising and the subsequent loss of directional control.NTSB GAA16CA440Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Palmer, AKThe pilot's excessive brake application during the landing roll resulting in a nose over.NTSB ERA16LA295Accident · No injuriesLimited investigationFinal reportPiper PA34 · Hollywood, FLMaintenance personnel’s failure to comply with an airworthiness directive for the propeller, which resulted in a propeller hub failure due to fatigue.NTSB CEN16LA326Accident · 1 fatalLimited investigationFinal reportThrush S2R T660 · Ruthton, MNThe pilot's failure to see and avoid the tower guy-wire during an agricultural spraying operation.NTSB CEN16FA328Accident · 1 fatalField investigationFinal reportAero Commander S2R · Center, COThe pilot's failure to maintain airplane control during a low-level maneuver, which resulted in an aerodynamic stall.NTSB WPR16FA166Accident · Minor injuriesField investigationFinal reportDouglas TA-4K · Las Vegas, NVForeign object debris in the engine's main fuel control unit, which restricted fuel flow and subsequently resulted in the loss of engine power. Contributing to the accident was the installation or addition of an extra seal during the main fuel control unit…NTSB GAA16CA439Accident · No injuriesData collectionFinal reportBell 206 L4 · Broussard, LAThe pilot's failure to attain a proper touchdown point, which resulted in the helicopter sliding off the aft end of the transport dolly.NTSB CEN16LA329Accident · Serious injuriesLimited investigationFinal reportCollins RV6A · Pekin, ILThe pilot's failure to latch the canopy before takeoff, and his subsequent distraction and failure to maintain control while attempting to close the open canopy, which resulted in an aerodynamic stall.NTSB GAA16CA455Accident · No injuriesData collectionFinal reportCessna U206 · Sleetmute, AKThe pilot's exceedance of the critical angle of attack during the landing flare, which resulted in an aerodynamic stall and a hard landing.NTSB GAA16CA441Accident · No injuriesData collectionFinal reportValloric Carl Stephen Valloric Sport Trnr · Cadiz, OHThe pilot's failure to maintain directional control during landing and the unintentional right brake application, which resulted in a runway excursion and a nose over.NTSB GAA16CA437Accident · No injuriesData collectionFinal reportCessna 152 · Belle Plaine, MNThe student pilot's improper pitch technique after rotation during a short field take off, which resulted in the right wing impacting the ground and a nose gear collapse.NTSB GAA16CA434Accident · No injuriesData collectionFinal reportCessna 182 · Anchorage, AKThe pilot's failure to maintain a controlled landing flare, which resulted in a hard landing. Contributing to the accident was the pilot's inattention and distraction.NTSB ERA16CA294Accident · No injuriesData collectionFinal reportCessna 152 · Newnan, GAThe student pilot's improper decision to land long and maintain excessive speed during the landing roll. Contributing to the accident was the student pilot's decision to maintain full flaps and aft yoke inputs at a higher speed, reducing his ability to stop…NTSB GAA16CA432Accident · No injuriesData collectionFinal reportCessna 150 · North Conway, NHThe pilot's improper fuel management, which resulted in fuel exhaustion, a total loss of engine power, a forced landing, and nose over.NTSB GAA16CA473Accident · No injuriesData collectionFinal reportCessna 172 · Fulton, MOThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing, which resulted in the airplane porpoising.NTSB GAA16CA430Accident · No injuriesData collectionFinal reportPzl-Swidnik PW 6U · Llano, CAThe pilot’s failure to properly secure the two aft canopy latches during the preflight inspection, which resulted in the canopy separating from the glider during the takeoff roll and substantial damage to the vertical stabilizer.NTSB ERA16FA289Accident · 6 fatalField investigationFinal reportPiper PA 31 · Northport, ALA total loss of power in both engines due to fuel starvation as a result of the pilot's fuel mismanagement, and his subsequent failure to follow the emergency checklist. Contributing to the pilot's failure to follow the emergency checklist was his lack of…NTSB CEN16LA324Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Lino Lakes, MNA partial loss of engine power due to the formation of carburetor ice, which resulted in reduced climb capability and impact with vegetation and terrain during takeoff.NTSB GAA16CA454Accident · No injuriesData collectionFinal reportPiper PA 34 · Fort Lauderdale, FLThe other pilot's failure to ensure that the brake was fully engaged and his subsequent failure to notice that his airplane was rolling forward, which resulted in it hitting another airplane.NTSB GAA16CA429Accident · No injuriesData collectionFinal reportConsolidated Vultee BT13 · Joseph, ORThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and damage to the left aileron and elevator.NTSB ERA16LA293Accident · No injuriesClass 3 · LimitedFinal reportCessna 150G · Shirley, NYMaintenance personnel’s inadequate maintenance and inspection of the airplane, which resulted in the left elevator attachment bolt backing out of the nutplate, and partial inflight separation and damage of the elevator.NTSB ERA16LA291Accident · Serious injuriesLimited investigationFinal reportLuscombe 8 · Marlboro, NJThe pilot's inadequate in-flight fuel management, which resulted in fuel exhaustion and the subsequent total loss of engine power.NTSB CEN16LA320Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR20 · Des Moines, IAThe two separations in the induction system due to improper installation and/or maintenance, which resulted in a partial loss of engine power during initial climb.NTSB ANC16LA059Accident · No injuriesLimited investigationFinal reportWight Carbon CUB CCK-1865 · Wasilla, AKThe failure of the tailwheel suspension assembly during landing due to preexisting fatigue fractures in the suspension system, which resulted in a loss of directional control.NTSB ANC16FA057Accident · 1 fatalField investigationFinal reportChampion 7ECA · Chugiak, AKThe pilot's failure to maintain proper airspeed and his exceedance of the airplane's critical angle of attack during a steep low-altitude turn following a loss of engine power, which resulted in an aerodynamic stall and subsequent loss of control at too low…NTSB WPR16LA165Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Gunnison, UTA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR16LA164Accident · Minor injuriesLimited investigationFinal reportZenith CH601 · Ocean Shores, WAA reduction in electrical power, which disabled both fuel pumps and resulted in fuel starvation and a loss of engine power.NTSB GAA16CA431Accident · No injuriesData collectionFinal reportCessna 152 · Hillsboro, ORThe student pilot's improper pitch control during the landing flare, which resulted in a porpoise and substantial damage to the engine mount.NTSB GAA16CA428Accident · No injuriesData collectionFinal reportGrumman American Avn. AA 5A · Reno, NVThe pilot's failure to see and avoid fence posts during landing, which resulted in substantial damage to the wings.NTSB ERA16FA288Accident · 6 fatalField investigationFinal reportBeech 95 B55 (T42A) · Fredericksburg, VAThe pilot(s) failure to maintain adequate airspeed during an attempted go-around, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.NTSB ERA16CA290Accident · Serious injuriesData collectionFinal reportKessinger Roger L Rans Coyote · London, KYThe student pilot's improper recovery from a bounced landing and his subsequent failure to maintain clearance from trees during an attempted go-around.NTSB GAA16CA433Accident · No injuriesData collectionFinal reportMaule MXT7 · Quitman, ARThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a nose over. Contributing to the accident was the pilot's limited forward visibility due to sun glare.NTSB GAA16CA427Accident · No injuriesData collectionFinal reportPiper PA28 · Hamburg, NYThe pilot's failure to perform a go-around, which resulted in a landing area overshoot, a runway overrun, a landing gear collapse, and a collision with a guard rail.NTSB GAA16CA425Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · San Diego, CAThe pilot's failure to maintain directional control during landing with a crosswind.NTSB CEN16LA322Accident · Serious injuriesLimited investigationFinal reportPiper J5C · Sandusky, MIThe pilot's improper landing flare, which resulted in a bounced landing, and a subsequent loss of control followed by a runway excursion.NTSB CEN16FA315Accident · 1 fatalField investigationFinal reportHughes 269C · Howe, TXThe improper execution of an autorotation following the loss of engine power, which resulted in an uncontrolled descent into terrain. Contributing to the accident was the flight instructor's lack of remedial action during the autorotation.NTSB CEN16LA316Accident · No injuriesLimited investigationFinal reportSchabacker Konrad J Acro Sport II · Winterset, IAThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in an on-ground collision with two parked airplanes.NTSB CEN16CA319Accident · No injuriesData collectionFinal reportCessna 172S · Arlington, TXThe student pilot's improper recovery from a bounced landing.NTSB CEN16CA317Accident · No injuriesData collectionFinal reportErcoupe 415 · Eminence, INThe pilot's failure to maintain a proper glide path during the landing approach and his failure to use available engine power to arrest the descent, resulting in an undershoot and collision with terrain.NTSB WPR16LA163Accident · No injuriesLimited investigationFinal reportCessna TR182 · Torrance, CAThe failure of the right main landing gear to fully extend for reasons that could not be determined because postaccident examination and testing did not reveal any evidence of preimpact mechanical failures or malfunctions that would have precluded normal…NTSB GAA16CA420Accident · No injuriesData collectionFinal reportCubcrafters CC11 · Hailey, IDThe flight instructor's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a ground loop.