NTSB investigations

19,008 cases where NTSB found Personnel issues.

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\", '02'))
  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 WPR18LA255Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Richland, MOA loss of directional control during a touch-and-go landing in gusting crosswind conditions.Sep 4, 2018 · N8028F · Substantial damageNTSB WPR18FA251Accident · 1 fatalClass 2 · FieldFinal reportMooney M20J · Palo Alto, CAThe pilot’s failure to maintain aircraft control during a go-around due to his premature flap retraction, which resulted in an aerodynamic stall and subsequent loss of control.Sep 4, 2018 · N701JM · Substantial damageNTSB WPR18FA249Accident · 1 fatalField investigationFinal reportCessna 150L · Pacoima, CAA loss of engine power shortly after takeoff due to fuel exhaustion, and the exceedance of the airplane's critical angle of attack when the flight instructor made an abrupt turn back toward the runway, which resulted in an aerodynamic stall/spin at an…Sep 4, 2018 · N10789 · Substantial damageNTSB 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 GAA18CA528Accident · No injuriesData collectionFinal reportBeech 200 · Burbank, CAThe flight instructor's and pilot receiving instruction's failure to maintain clearance from a tree while taxiing.Sep 3, 2018 · N97WC · 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 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 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 CEN18LA370Accident · No injuriesLimited investigationFinal reportCubcrafters CC11-160 · Lancaster, OHThe delayed application of carburetor heat by the pilot which led to accumulation of carburetor ice, eventual loss of engine power, and the subsequent forced landing in high vegetation.Aug 31, 2018 · N71BN · Substantial damageNTSB CEN18FA359Accident · 2 fatalField investigationFinal reportPiper PA28R · Kaplan, LAThe pilot's failure to maintain clearance from a charted and illuminated television/radio tower.Aug 31, 2018 · N7430J · DestroyedNTSB 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 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 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 ERA18FA235Accident · 1 fatalField investigationFinal reportAirtime Cygnet · Pensacola, FLThe student pilot's loss of aircraft control for undetermined reasons.Aug 27, 2018 · N186AT · 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 CEN18LA351Accident · No injuriesLimited investigationFinal reportCessna P210 · Delaware, OHThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s distraction of the formation flight.Aug 26, 2018 · N4842K · 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 damage