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 GAA18CA532Accident · No injuriesData collectionFinal reportCessna 206 · London, KYThe pilot’s failure to maintain directional control during takeoff with a tailwind.Sep 4, 2018 · N230DE · Substantial damageNTSB WPR18LA252Accident · No injuriesClass 3 · LimitedFinal reportGuimbal Cabri · Santa Ana, CAThe flight instructor's delayed application of power during a power recovery following an autorotation, which resulted in an unrecoverable low rotor rpm during the landing flare and subsequent loss of control.Sep 3, 2018 · N401SH · Substantial damageNTSB GAA18CA539Accident · No injuriesData collectionFinal reportSchweizer 269C · Delaware, OHThe pilot’s improper landing flare, which resulted in a hard landing.Sep 3, 2018 · N139JS · Substantial damageNTSB CEN18LA365Accident · Serious injuriesLimited investigationFinal reportMD Helicopters MD-369 · Orchard Lake, MIThe pilot's failure to maintain helicopter control and terrain clearance while in a hover after performing an evasive maneuver to avoid wildlife.Sep 3, 2018 · N1601Y · Substantial damageNTSB ANC18LA069Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Wrangell, AKThe total loss of engine power due to oil starvation after an interruption of oil circulation for reasons that could not be determined based on the available evidence.Sep 3, 2018 · N3957X · Substantial damageNTSB WPR18FA247Accident · 2 fatalClass 3 · FieldFinal reportSchempp-Hirth Duo Discus T · New Washoe City, NVThe pilot’s delayed recovery from an inadvertent spin and/or spiral dive and an exceedance of the glider’s design limit load during recovery, which resulted in an overload failure of both wings.Sep 2, 2018 · N22XC · DestroyedNTSB GAA18CA572Accident · No injuriesData collectionFinal reportCessna 180 · Yakutat, AKThe pilot’s failure to maintain lateral control of the airplane during a step-turn takeoff.Sep 2, 2018 · N95EA · Substantial damageNTSB GAA18CA536Accident · No injuriesData collectionFinal reportAeronca 11AC · Midland, TXThe pilot’s improper landing flare, which resulted in a bounced landing.Sep 2, 2018 · N86146 · Substantial damageNTSB GAA18CA531Accident · No injuriesData collectionFinal reportPiper PA44 · Centralia, ILThe pilot receiving instruction's failure to extend the landing gear and the flight instructor's failure to verify that the landing gear was extended before landing. Contributing to the accident was the flight instructor’s delayed remedial action and…Sep 2, 2018 · N2204X · Substantial damageNTSB GAA18CA522Accident · No injuriesData collectionFinal reportPiper PA 12 · Rexburg, IDThe pilot's improper landing flare, which resulted in the airplane bouncing and a subsequent loss of directional control, a runway excursion, and impact with a fence.Sep 2, 2018 · N4077M · Substantial damageNTSB ERA18LA242Accident · Serious injuriesClass 3 · LimitedFinal reportStinson 108 · Indiana, PAA total loss of engine power as a result of debris contamination of the fuel, which resulted in fuel starvation.Sep 2, 2018 · N4059C · Substantial damageNTSB CEN18LA364Accident · Serious injuriesLimited investigationFinal reportLindstrand 77A · Brookfield, MOThe pilot's inability to maintain control of the balloon after encountering high wind conditions and windshear during the landing, which resulted in his ejection from the basket and serious injury to the passenger during the balloon’s subsequent impact with…Sep 2, 2018 · N370LB · No damageNTSB GAA18CA557Accident · No injuriesData collectionFinal reportSchweizer SGS 1 35 · Burnet, TXThe pilot's failure to extend the landing gear before landing and to use the Before Landing checklist.Sep 1, 2018 · N34107 · Substantial damageNTSB GAA18CA551Accident · No injuriesData collectionFinal reportPiper PA28 · Cypress, TXThe student pilot’s improper approach path after the airplane encountered turbulence, which resulted in the airplane landing hard short of the runway.Sep 1, 2018 · N212NA · Substantial damageNTSB GAA18CA550Accident · No injuriesData collectionFinal reportBoeing B75N1 · Culpeper, VAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.Sep 1, 2018 · N27WE · Substantial damageNTSB GAA18CA527Accident · No injuriesData collectionFinal reportCessna 170 · Tulsa, OKThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.Sep 1, 2018 · N2303D · Substantial damageNTSB GAA18CA526Accident · No injuriesData collectionFinal reportCessna 172 · Karluk, AKThe pilot’s failure to maintain proper pitch for a soft-field landing, which resulted in a loss of airplane control.Sep 1, 2018 · N3835S · Substantial damageNTSB GAA18CA525Accident · No injuriesData collectionFinal reportPiper PA18 · Palmer, AKThe pilot’s failure to maintain directional control during takeoff.Sep 1, 2018 · N5373Y · Substantial damageNTSB GAA18CA523Accident · Minor injuriesData collectionFinal reportEggleston Daniel S-18 Thorp · Porterville, CAThe pilot’s failure to maintain directional control during the takeoff roll.Sep 1, 2018 · N575DG · Substantial damageNTSB ERA18FA240Accident · 1 fatalField investigationFinal reportLance M Hooley Jetez · Covington, TNThe improper manufacture of the left wing, which resulted in a left wing flutter event and failure at low altitude and high speed.Sep 1, 2018 · N815EY · DestroyedNTSB CEN18TA374Accident · Minor injuriesFinal reportBeech 35 · Harrisville, MIThe pilot’s delayed decision to abort the takeoff, which resulted in the loss of lateral control of the airplane and collision with trees at the end of the runway. Contributing to the accident was the pilot’s decision to depart with a center of gravity…Sep 1, 2018 · N5321E · Substantial damageNTSB CEN18LA363Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Crete, NEThe stuck turbocharger wastegate in the closed position for reasons that could not be determined based on the available information. Also causal was the pilot's failure to reduce the throttle during takeoff when the manifold pressure and fuel flow exceeded…Sep 1, 2018 · N210PF · Substantial damageNTSB CEN18LA361Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 55 · Waupaca, WIThe total loss of engine power due to fuel exhaustion.Sep 1, 2018 · N10DS · Substantial damageNTSB CEN18FA368Accident · 1 fatalField investigationFinal reportPiper PA32RT · St Ignace, MIThe pilot's failure to maintain sufficient altitude after takeoff in dark night conditions which resulted in a collision with the water.Sep 1, 2018 · N500MJ · DestroyedNTSB WPR18LA246Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Tehachapi, CAThe pilot's inadequate fuel planning, which resulted in fuel exhaustion and a total loss of engine power during the initial climb.Aug 31, 2018 · N2167V · Substantial damageNTSB GAA18CA579Accident · Minor injuriesData collectionFinal reportPiper PA28 · Porterville, CAThe pilot's failure to maintain directional control during the landing roll.Aug 31, 2018 · N8172N · Substantial damageNTSB CEN18LA383Accident · No injuriesLimited investigationFinal reportPiper PA46 · Santa Teresa, NMThe pilot's decision to attempt to take off in an overweight airplane in high density altitude conditions, which resulted in the airplane’s inability to climb, an aborted takeoff, and a subsequent runway excursion.Aug 31, 2018 · N747DA · Substantial damageNTSB CEN18LA360Accident · No injuriesLimited investigationFinal reportStearman A75N1(PT17) · Kenosha, WIThe failed retaining bolt and cracked backing plate, which resulted in a shift of the brake lining to contact the brake drum and a subsequent wheel lock when the brakes were applied.Aug 31, 2018 · N64604 · Substantial damageNTSB WPR18FA245Accident · 1 fatalClass 2 · FieldFinal reportCessna P210 · Prescott, AZThe pilot's misjudgment of distance and altitude from the runway and his subsequent failure to maintain an approach path that provided clearance from the terrain due to a visual illusion in dark night conditions.Aug 30, 2018 · N6500W · DestroyedNTSB CEN18FA358Accident · 4 fatalField investigationFinal reportBeech B60 · Fort Walton Beach, FLThe pilot's controlled flight into terrain after misidentifying the destination airport during a period of restricted visibility due to weather.Aug 30, 2018 · N1876L · DestroyedNTSB WPR18LA248Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Tat Momoli, AZA total loss of engine power due to a fatigue crack in the connecting rod bushing end.Aug 29, 2018 · N4139A · Substantial damageNTSB WPR18FA244Accident · 1 fatalField investigationFinal reportCessna 150 · Redding, CAThe pilot's exceedance of the airplane's critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot's failure to properly configure the wing flaps for…Aug 29, 2018 · N7990F · Substantial damageNTSB ERA18FA238Accident · 3 fatalField investigationFinal reportSchweizer SGS 2 32 · Morrisville, VTThe pilot's exceedance of the glider's critical angle of attack while maneuvering, which resulted in an aerodynamic stall/spin and impact with terrain. Contributing to the accident was the pilot's decision to operate the glider outside of its published weight…Aug 29, 2018 · N17970 · Substantial damageNTSB CEN18LA357Accident · No injuriesLimited investigationFinal reportGrumman G164 · Opelousas, LAThe loss of two securing bolts that allowed the left magneto to move around, which disrupted the spark timing and resulted in the engine losing total power.Aug 29, 2018 · N956X · Substantial damageNTSB GAA18CA529Accident · No injuriesData collectionFinal reportPiper PA46 · Hartford, CTThe pilot’s unstabilized approach and hard landing, which resulted in a nose landing gear collapse.Aug 28, 2018 · N178DB · Substantial damageNTSB GAA18CA524Accident · No injuriesData collectionFinal reportLuscombe 8 · Fulton, MOThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.Aug 28, 2018 · N1211B · Substantial damageNTSB WPR18LA250Accident · No injuriesLimited investigationFinal reportStoddard Hamilton Glasair Super IIS · Yuma, AZA total loss of engine power as a result of the detachment of the throttle linkage from the throttle arm of the fuel injector servo due to an insufficiently tightened and secured bolt and the subsequent inadequate maintenance inspection.Aug 27, 2018 · N8162H · Substantial damageNTSB GAA18CA514Accident · No injuriesData collectionFinal reportCessna 150 · Eldorado, TXThe pilot’s improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Aug 27, 2018 · N1701Q · Substantial damageNTSB GAA18CA513Accident · No injuriesData collectionFinal reportCessna 172 · Winchester, VAThe student pilot's failure to maintain directional control during the takeoff roll.Aug 27, 2018 · N53051 · Substantial damageNTSB ERA18TA236Accident · No injuriesFinal reportCessna 182 · Hanson, MAThe pilot's failure to attain the proper touchdown point, which resulted in a runway overrun. Contributing to the accident was the pilot's decision to land with a quartering tailwind.Aug 27, 2018 · N3115R · Substantial damageNTSB CEN18LA352Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Rushville, INLoss of engine power due to carburetor icing and the pilot's failure to use carburetor heat in weather conditions conducive to carburetor icing.Aug 27, 2018 · N4379L · Substantial damageNTSB GAA18CA511Accident · No injuriesData collectionFinal reportMooney M20J · Rochester, NHThe pilot’s failure to maintain directional control during takeoff.Aug 26, 2018 · N201BS · Substantial damageNTSB ERA18LA233Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · New Kent, VAThe student pilot’s loss of airplane control during a go-around.Aug 26, 2018 · N1537U · Substantial damageNTSB CEN18LA354Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Bowman, NDThe loss of engine power due to fuel starvation.Aug 26, 2018 · N666WW · Substantial damageNTSB WPR18LA242Accident · Serious injuriesClass 3 · LimitedFinal reportBell 212 · Dardanelle, CAAn in-flight failure of the trunnion bearing and subsequent failure of the drive link and swashplate support, which resulted in the loss of helicopter control.Aug 25, 2018 · N512TA · Substantial damageNTSB GAA18CA554Accident · No injuriesData collectionFinal reportAirborne Edge X Classic · Lake Wales, FLThe student pilot's improper landing flare, which resulted in a hard landing.Aug 25, 2018 · N4557C · Substantial damageNTSB GAA18CA540Accident · No injuriesData collectionFinal reportYakovlev YAK 52 · East Stroudsburg, PAThe pilot's failure to extend the landing gear during landing, which resulted in a runway excursion and subsequent impact with terrain.Aug 25, 2018 · N3042W · Substantial damageNTSB GAA18CA517Accident · No injuriesData collectionFinal reportChampion 7GCBC · Ocklawaha, FLThe pilot’s failure to maintain directional control during landing.Aug 25, 2018 · N7618S · Substantial damageNTSB GAA18CA516Accident · No injuriesData collectionFinal reportPiper PA28 · Point Lookout, MOThe student pilot's inadvertent left brake application during the landing roll, which resulted in a runway excursion and collision with runway lights.Aug 25, 2018 · N7635F · Substantial damageNTSB GAA18CA509Accident · No injuriesData collectionFinal reportCessna 170 · Prineville, ORThe pilot's failure to maintain directional control during the landing roll.Aug 25, 2018 · N4569C · Substantial damage