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.

NTSB CEN16LA375Accident · No injuriesLimited investigationFinal reportPiper PA 32R-300 · Grants, NMA loss of engine power for reasons that could not be determined based on the available information.Sep 19, 2016 · N4477F · DestroyedNTSB CEN16FA373Accident · 2 fatalField investigationFinal reportCessna 182 · Ephraim, WIThe pilot's improper decision to execute a maneuvering approach at low altitude during night conditions, which resulted in controlled flight into terrain.Sep 19, 2016 · N2012F · DestroyedNTSB WPR16LA187Accident · No injuriesLimited investigationFinal reportJurcan Seawind 3000 · Renton, WAThe failure of the landing gear system to either fully retract or extend due to a cracked hydraulic fitting flare, which resulted in the loss of hydraulic pressure.Sep 18, 2016 · N57TJ · Substantial damageNTSB WPR16FA183Accident · Serious injuriesField investigationFinal reportCessna 182P · Gilbert, AZAn inadvertent explosion of pyrotechnics, which were contained in a box that had been installed on the airplane's left main landing gear assembly spring leg which resulted in shrapnel striking the airplane's left wing and breaching the left wing fuel tank,…Sep 18, 2016 · N20844 · DestroyedNTSB GAA16LA525Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Davis, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and noseover. Contributing to the accident was the failure of the seatbelt anchor bracket.Sep 18, 2016 · N76284 · Substantial damageNTSB GAA16CA511Accident · No injuriesData collectionFinal reportCessna 172 · Auburn, CAThe pilot's improper landing flare, which resulted in a hard, bounced landing.Sep 18, 2016 · N7560D · Substantial damageNTSB ERA16LA319Accident · Minor injuriesClass 3 · LimitedFinal reportGrumman G164 · Chestertown, MDLoss of engine power due to a failure of the No. 3 cylinder head, which resulted in a forced landing and collision with ground equipment.Sep 18, 2016 · N75EP · Substantial damageNTSB ANC16CA066Accident · No injuriesData collectionFinal reportPiper PA 18 · McGrath, AKThe pilot's excessive taxi speed, which resulted in a loss of control and subsequent nose over.Sep 18, 2016 · N5773D · Substantial damageNTSB WPR16LA184Accident · No injuriesLimited investigationFinal reportOGG Richard A OGG Glasair I · Reno, NVThe failure of an induction elbow following an engine backfire, which resulted in an in-flight fire and loss of engine power.Sep 17, 2016 · N70GG · Substantial damageNTSB GAA16CA509Accident · Minor injuriesData collectionFinal reportGrumman G44 · Lakeport, CAThe pilot's failure to retract the landing gear, which resulted in a gear-down water landing and a nose over.Sep 17, 2016 · N111W · Substantial damageNTSB GAA16CA500Accident · No injuriesData collectionFinal reportAerotek Pitts Special · Reno, NVThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground loop.Sep 17, 2016 · N91JW · Substantial damageNTSB GAA16CA499Accident · No injuriesData collectionFinal reportAlex Michael Bantum/Tercel USA TERCEL-GYROPLANE · Blairstown, NJThe student pilot’s incorrect takeoff procedure, which resulted in a loss of main rotor rpm and the subsequent loss of directional control and runway excursion.Sep 17, 2016 · N528WM · Substantial damageNTSB CEN16FA372Accident · Serious injuriesField investigationFinal reportAgusta A109 · Alexandria, MNThe pilot's excessive cyclic input during a missed approach maneuver in night instrument meteorological conditions, which resulted in a loss of control and spiraling descent into terrain.Sep 17, 2016 · N91NM · DestroyedNTSB GAA16CA523Accident · No injuriesData collectionFinal reportCessna 172 · Tooele, UTThe pilot's improper landing flare, which resulted in a hard, bounced landing.Sep 16, 2016 · N461SP · Substantial damageNTSB GAA16CA519Accident · No injuriesData collectionFinal reportBeech G35 · Kooskia, IDThe pilot’s failure to extend the landing gear during landing.Sep 16, 2016 · N168B · Substantial damageNTSB GAA16CA498Accident · No injuriesData collectionFinal reportAirtime Cygnet · Venice, FLThe student pilot’s failure to maintain directional control during the takeoff roll and the flight instructor’s delayed remedial action, which resulted in a runway excursion.Sep 16, 2016 · N145AT · Substantial damageNTSB GAA16CA494Accident · No injuriesData collectionFinal reportBeech B23 · Raleigh, NCThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion.Sep 16, 2016 · N4002T · Substantial damageNTSB ERA16FA316Accident · 1 fatalField investigationFinal reportCessna A188 · Alapaha, GAThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude during aerial application operations, which resulted in the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall and spin.Sep 16, 2016 · N3547Q · DestroyedNTSB ANC16LA068Accident · Serious injuriesLimited investigationFinal reportJeffery D Tuttle BDK Carbon Concepts · Wasilla, AKThe structural failure of both wings’ leading-edge slats, which resulted in a loss of airplane control.Sep 16, 2016 · N8008Z · Substantial damageNTSB ANC16LA067Accident · No injuriesLimited investigationFinal reportHelio H 295 · Fairbanks, AKExcessive side loads imposed on the tailwheel A-frame during the takeoff roll, which resulted in a separation of the tailwheel and the subsequent loss of directional control.Sep 16, 2016 · N6464V · Substantial damageNTSB GAA16CA491Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Valparaiso, INThe pilot’s improper landing flare, which resulted in a bounced landing.Sep 15, 2016 · N3331R · Substantial damageNTSB GAA16CA490Accident · No injuriesData collectionFinal reportPiper PA 28 · Parkersburg, WVThe flight instructor’s delayed remedial action during the approach for landing, which resulted in impact with terrain short of the runway threshold. Contributing to the accident was the student pilot’s failure to maintain an appropriate descent rate during…Sep 15, 2016 · N5673U · Substantial damageNTSB GAA16CA488Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Cedar City, UTThe flight instructor’s delayed remedial action while providing hover instruction in gusting wind conditions, which resulted in dynamic roll-over.Sep 14, 2016 · N46HF · Substantial damageNTSB CEN16FA370Accident · 2 fatalField investigationFinal reportPiper PA 11 · Arcanum, OHThe student pilot's reckless flying attitude and use of multiple psychoactive drugs, which likely impaired his ability to maintain clearance from terrain while maneuvering at low altitude.Sep 14, 2016 · N4910M · Substantial damageNTSB CEN16LA374Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Bowling Green, OHThe pilots’ failure to complete the Emergency Landing Gear Extension checklist and maintenance personnel’s failure to correctly repair spliced wires on the left main landing gear down limit switch, which prevented the pilots from knowing whether the gear was…Sep 13, 2016 · N786BG · Substantial damageNTSB WPR16LA188Accident · No injuriesLimited investigationFinal reportBell 206B · Rockport, WAThe pilot's failure to maintain helicopter control while on the ground, which resulted in mast bumping.Sep 12, 2016 · N6181A · Substantial damageNTSB WPR16FA178Accident · 3 fatalField investigationFinal reportPiper PA 28R-201T · Reno, NVThe pilot's decision to depart with the airplane loaded above its maximum gross weight and at or just beyond its aft center of gravity limitations, which resulted in a loss of control during the initial climb. Contributing to the accident was the pressure to…Sep 12, 2016 · N821ET · DestroyedNTSB GAA16CA484Accident · No injuriesData collectionFinal reportCessna 182 · Olathe, KSThe pilot’s failure to reduce the throttle during the landing roll resulting in a loss of directional control.Sep 12, 2016 · N90391 · Substantial damageNTSB GAA16CA483Accident · No injuriesData collectionFinal reportCessna 172 · Covington, GAThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Sep 12, 2016 · N5283R · Substantial damageNTSB GAA16CA522Accident · No injuriesData collectionFinal reportDieterich Robert A AIR CAM · McCall, IDThe pilot’s improper landing flare, which resulted in a hard landing and the left main landing gear wheel separating from the airplane, followed by an aborted landing, and a subsequent ground loop during the follow-on landing.Sep 11, 2016 · N322BD · Substantial damageNTSB CEN16LA366Accident · Serious injuriesLimited investigationFinal reportPiper PA 18 · Greenville, MIThe pilot's premature turn during the takeoff climb and subsequent turn to avoid trees, which resulted in his exceedance of the airplane’s critical angle-of-attack and a subsequent aerodynamic stall.Sep 11, 2016 · N3286Z · Substantial damageNTSB ANC16FA065Accident · 1 fatalField investigationFinal reportHefty Polar Cub · Anchorage, AKThe pilot's severe impairment from carbon monoxide poisoning in flight, which resulted in a loss of control and a subsequent collision with trees and terrain.Sep 11, 2016 · N62905 · DestroyedNTSB WPR16LA179Accident · No injuriesClass 3 · LimitedFinal reportMccluskey Challenger II · Bisbee, AZA total loss of engine power for reasons that could not be determined based on the available information.Sep 10, 2016 · N6162Y · Substantial damageNTSB GAA16CA492Accident · No injuriesData collectionFinal reportCessna 170 · Sidney, MTThe student pilot’s improper landing flare, which resulted in a bounced landing, and the flight instructor’s inability to recover the airplane, which resulted in a runway excursion.Sep 10, 2016 · N8335A · Substantial damageNTSB GAA16CA476Accident · No injuriesData collectionFinal reportLuscombe 8 · Juneau, WIThe pilot's failure to maintain directional control during the landing roll in gusting crosswind conditions, which resulted in a runway excursion. Contributing to the accident was the foot pad cover slipping off the right rudder pedal during the landing roll.Sep 10, 2016 · N1263K · Substantial damageNTSB GAA16CA475Accident · No injuriesData collectionFinal reportBeech 200 · Apopka, FLThe pilot's failure to maintain directional control during an attempted aborted landing in gusty crosswind conditions, which resulted in a runway excursion and an impact with a tree.Sep 10, 2016 · N369CD · Substantial damageNTSB WPR16FA176Accident · Serious injuriesField investigationFinal reportCessna 310N · Wickenburg, AZTotal loss of power to the right engine during takeoff due to a fuel contaminant, which blocked the fuel flow transducer and resulted in fuel starvation to the engine.Sep 9, 2016 · N126P · Substantial damageNTSB GAA16CA524Accident · Minor injuriesData collectionFinal reportVan Hoomissen Gerald J Murphy Elite · Nordman, IDThe floatplane pilot's improper landing flare during landing on choppy water with a tailwind, which resulted in a nose-over. Contributing to the accident was the pilot's failure to determine the wind direction before landing.Sep 9, 2016 · N567AK · Substantial damageNTSB GAA16CA505Accident · No injuriesData collectionFinal reportPiper PA46R · Reserve, NMThe pilot’s failure to maintain directional control during landing with a crosswind.Sep 9, 2016 · N563WT · Substantial damageNTSB GAA16CA489Accident · No injuriesData collectionFinal reportBurkhart Grob Flugzeugbau G109 · Emigrant Gap, CAThe pilot's inappropriate decision to continue the flight into higher elevation under high-density altitude conditions, which degraded the glider's climb performance and resulted in impact with trees short of the intended runway.Sep 9, 2016 · N909G · Substantial damageNTSB GAA16CA482Accident · No injuriesData collectionFinal reportPiper PA18 · Gulkana, AKThe pilot’s failure to maintain clearance from a tree while maneuvering at low altitude.Sep 9, 2016 · N13833 · Substantial damageNTSB GAA16CA477Accident · No injuriesData collectionFinal reportPacific Aerospace 750XL · Warrenton, VAThe pilot's failure to set the wing flaps for takeoff, which resulted in an aerodynamic stall, an aborted takeoff, and a runway overrun.Sep 9, 2016 · N750SS · Substantial damageNTSB ERA16CA314Accident · Minor injuriesData collectionFinal reportQuicksilver Manufacturing Sport 2S · Cleveland, GAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Sep 9, 2016 · N396DF · Substantial damageNTSB ANC16LA062Accident · Serious injuriesClass 3 · LimitedFinal reportDehavilland DHC-2 · Kodiak, AKThe pilot's failure to maintain adequate airspeed during the initial climb and turn after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.Sep 9, 2016 · N91AK · Substantial damageNTSB GAA16CA481Accident · Minor injuriesData collectionFinal reportStinson L 5 · San Antonio, TXThe pilot’s failure to maintain directional control during the landing roll.Sep 8, 2016 · N178 · Substantial damageNTSB GAA16CA470Accident · No injuriesData collectionFinal reportCessna 182 · Diller, NEThe pilot's failure to go around after overshooting his intended touchdown point, which resulted in impact with farm equipment and terrain during an aborted landing attempt.Sep 7, 2016 · N1928X · Substantial damageNTSB ERA16FA312Accident · 3 fatalField investigationFinal reportBeech F33 · Carrollton, GAThe failure of the Beech pilot to see and avoid the Diamond that was in front of and below his airplane on final approach and his use of an incorrect radio communication frequency for the airport.Sep 7, 2016 · N6027K · 2 aircraft · Substantial damageNTSB CEN16FA361Accident · 1 fatalField investigationFinal reportPiper PA 46-310P · Chariton, IAThe non-instrument-rated pilot's loss of control due to spatial disorientation in instrument meteorological conditions, which resulted in an exceedance of the airplane's design stress limitations and a subsequent in-flight breakup. Contributing to the…Sep 7, 2016 · N465JM · Substantial damageNTSB GAA16CA512Accident · No injuriesData collectionFinal reportAir Tractor AT802 · Wilson, ARThe pilot’s failure to adequately survey the area of operation and his subsequent failure to maintain clearance from power lines during an agricultural application flight.Sep 6, 2016 · N519EP · Substantial damageNTSB GAA16CA469Accident · Minor injuriesData collectionFinal reportRainbow Sky Reach Bushcat · Frankfort, KYThe pilot's exceedance of the airplane's critical angle-of-attack while maneuvering at low altitude, which resulted in an aerodynamic stall.Sep 6, 2016 · N2899X · Substantial damage