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 GAA19CA104Accident · No injuriesData collectionFinal reportPiper PA28 · Bowling Green, OHThe student pilot's failure to maintain directional control upon touchdown, which resulted in a runway excursion and impact with a ditch.Jan 6, 2019 · N282BG · Substantial damageNTSB CEN19LA059Accident · No injuriesLimited investigationFinal reportCessna T210 · Flint, MIThe failure of the nose landing gear actuator hydraulic hose, which resulted in the loss of hydraulic fluid and hydraulic system pressure and a subsequent gear-up landing.Jan 6, 2019 · N1237M · Substantial damageNTSB GAA19CA127Accident · Serious injuriesData collectionFinal reportLuscombe 8 · Casa Grande, AZThe pilot's failure to maintain yaw control and his exceedance of the airplane’s critical angle of attack during an aborted landing, which resulted in an aerodynamic stall.Jan 5, 2019 · N71155 · Substantial damageNTSB GAA19CA116Accident · No injuriesData collectionFinal reportBeech 24 · Edgewood, NMThe pilot's improper landing flare, which resulted in hard, bounced landing, loss of directional control, runway excursion, and impact with a fence and terrain during an attempted go-around.Jan 4, 2019 · N6588R · Substantial damageNTSB GAA19CA117Accident · No injuriesData collectionFinal reportPiper PA 18-135 · Longmont, COThe pilot's failure to maintain directional control during landing.Jan 3, 2019 · N89018 · Substantial damageNTSB GAA19CA112Accident · No injuriesData collectionFinal reportZlin Savage · Prescott, AZThe pilot's failure to maintain directional control during the landing roll with a tailwind.Jan 3, 2019 · N808JD · Substantial damageNTSB GAA19CA110Accident · No injuriesData collectionFinal reportRobinson R44 · Grace, IDThe pilot's failure to maintain clearance from the power lines.Jan 3, 2019 · N4246Z · Substantial damageNTSB ERA19LA085Accident · No injuriesLimited investigationFinal reportPiper PA24 · Wilkes-Barre, PAThe pilot/mechanic's improper installation and securing of the mixture control cable, which led to a simultaneous loss of total engine power and failure of the nose landing gear to fully extend when the cable caught on the nose landing gear assembly.Jan 3, 2019 · N6872P · Substantial damageNTSB WPR19LA055Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 180 · Townsend, MTThe pilot’s failure to maintain clearance from power lines while maneuvering at low level, which resulted in a wire strike and subsequent impact with terrain.Jan 2, 2019 · N4934A · Substantial damageNTSB WPR19LA054Accident · 1 fatalClass 3 · LimitedFinal reportProgressive Aerodyne Searey · Sacramento, CAThe pilot's failure to properly configure the landing gear before performing a water landing.Jan 2, 2019 · N24YD · Substantial damageNTSB GAA19CA124Accident · Serious injuriesData collectionFinal reportRobinson R44 · Santa Maria Island, FLThe pilot's loss of helicopter control while maneuvering at a low altitude after being struck in the head by a bird.Jan 2, 2019 · N772MG · Substantial damageNTSB GAA19CA118Accident · No injuriesData collectionFinal reportCessna 172 · Appleton, MNThe student pilot’s loss of directional control while landing on an ice-covered runway, which resulted in a loss of directional control, and his failure to attain sufficient airspeed during a subsequent aborted landing, which resulted in a nose-over.Jan 2, 2019 · N12181 · Substantial damageNTSB DCA19CA066Accident · No injuriesData collectionFinal reportBoeing 757 · Charlotte, NCan inadvertent loss of airspeed and increased pitch attitude prior to touchdown.Dec 31, 2018 · N938UW · Substantial damageNTSB CEN19LA051Accident · 1 fatalLimited investigationFinal reportPiper PA 23 · Beaver Island, MIThe pilot's failure to maintain a positive rate of climb after takeoff which resulted in an impact with trees and terrain. Contributing to the accident was the pilot's inability to see a visible horizon due to the dark night lighting conditions and limited…Dec 31, 2018 · N2146P · DestroyedNTSB GAA19CA106Accident · No injuriesData collectionFinal reportCessna 172 · Caldwell, NJThe student pilot's failure to maintain directional control during the takeoff roll.Dec 30, 2018 · N2651R · Substantial damageNTSB GAA19CA111Accident · Minor injuriesData collectionFinal reportCessna 180 · Bend, ORThe pilot's failure to maintain directional control in gusting crosswind conditions.Dec 29, 2018 · N7757C · Substantial damageNTSB CEN19LA064Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Horseshoe Bay, TXThe pilot's inadequate preflight and in-flight fuel planning, which resulted in the total loss of engine power due to fuel exhaustion.Dec 29, 2018 · N6202M · Substantial damageNTSB CEN19LA050Accident · 1 fatalLimited investigationFinal reportCessna R172K · Chesaning, MIThe pilot's loss of airplane control for reasons that could not be determined based on the available information.Dec 29, 2018 · N1095V · DestroyedNTSB GAA19CA119Accident · No injuriesData collectionFinal reportCessna 172 · Sugar Land, TXThe student pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with a sign.Dec 27, 2018 · N17SJ · Substantial damageNTSB CEN19TA075Accident · Minor injuriesFinal reportMBB BK117 · Strum, WIThe pilot's failure to maintain clearance from the fire truck.Dec 25, 2018 · N145EC · Substantial damageNTSB CEN19LA049Accident · 2 fatalClass 2 · LimitedFinal reportBeech 58 · Sioux Falls, SDThe pilot's failure to maintain adequate airspeed during the instrument approach which led to an aerodynamic stall.Dec 25, 2018 · N6745V · DestroyedNTSB CEN19LA048Accident · No injuriesClass 3 · LimitedFinal reportVans RV 6 · Watkins, COThe pilot’s failure to apply adequate torque to a fuel line during recent maintenance, which allowed the line to loosen in flight and fuel to enter the hot engine compartment and resulted in an in-flight fire that consumed the airplane.Dec 25, 2018 · N711KJ · DestroyedNTSB ANC19CA009Accident · No injuriesData collectionFinal reportCessna A185 · Big Lake, AKThe pilot's improper decision to land on a roadway during dark night conditions with inoperable landing and taxi lights, which resulted in an impact with a snow berm.Dec 23, 2018 · N93018 · Substantial damageNTSB ERA19LA078Accident · 1 fatalLimited investigationFinal reportBRM Aero Bristell S-LSA · Lakeland, FLThe student pilot's exceedance of the airplane's critical angle of attack during the initial climb, resulting in an aerodynamic stall from which the pilot did not recover.Dec 22, 2018 · N587BL · DestroyedNTSB WPR19LA049Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft L 2M · Walla Walla, WAThe pilot's improper preflight planning, which resulted in a total loss of engine power due to fuel exhaustion.Dec 21, 2018 · N46147 · Substantial damageNTSB GAA19CA129Accident · No injuriesData collectionFinal reportCessna 182 · Marshall, TXThe pilot's failure to maintain directional control during landing.Dec 21, 2018 · N23YR · Substantial damageNTSB CEN19LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Abilene, TXThe pilot's failure to see and avoid a cell tower wire during a pipeline patrol flight. Contributing to the accident was the pilot's distraction due to writing down observations about the pipeline while flying.Dec 21, 2018 · N254RA · Substantial damageNTSB GAA19CA123Accident · Minor injuriesData collectionFinal reportCessna 172 · Center, TXThe pilot's exceedance of the airplane's critical angle of attack during landing in gusting crosswind conditions, which resulted in an aerodynamic stall.Dec 20, 2018 · N8487X · Substantial damageNTSB ERA19LA072Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA46 · Mayport, FLAn in-flight loss of control following an encounter with supercooled large droplet icing conditions, which ultimately resulted in an uncontrolled descent and subsequent inflight breakup. Also causal was the pilot’s failure to maintain an appropriate airspeed…Dec 20, 2018 · N307JM · DestroyedNTSB ERA19FA071Accident · 4 fatalField investigationFinal reportCessna 560 · Atlanta, GAThe pilot's loss of airplane control due to spatial disorientation during initial climb in instrument meteorological conditions.Dec 20, 2018 · N188CW · DestroyedNTSB ERA19FA070Accident · 3 fatalField investigationFinal reportPiper PA28 · Blairsville, GAThe pilot's failure to maintain clearance from trees during a visual approach for landing in night visual meteorological conditions. Contributing to the accident was the pilot's lack of recent experience flying at night.Dec 20, 2018 · N6143J · Substantial damageNTSB GAA19CA102Accident · No injuriesData collectionFinal reportBeech 36 · Sedona, AZThe pilot's failure to maintain the proper airspeed during landing, which resulted in the airplane landing too fast and too far down the runway to safely stop it.Dec 19, 2018 · N636M · Substantial damageNTSB ERA19LA074Accident · Minor injuriesClass 3 · LimitedFinal reportDiamond DA20 · McCormick, SCA partial loss of engine power due to debris obstructing the metering plug orifice in the throttle and metering unit.Dec 19, 2018 · N346MA · Substantial damageNTSB ERA19FA068Accident · 1 fatalClass 2 · FieldFinal reportSaberwing Saberwing · Adel, GAThe in-flight failure of the fuselage, as a result of the pilot conducting maneuvers that exceeded the structural capabilities of the airplane.Dec 18, 2018 · N203SW · Substantial damageNTSB WPR19FA042Accident · 1 fatalClass 2 · FieldFinal reportPiper PA-24-250 · Aberdeen, IDThe pilot's diverted attention during the takeoff climb due to a loss of engine power, which resulted in the airplane’s exceedance of the critical angle of attack and subsequent stall/spin.Dec 17, 2018 · N6283P · Substantial damageNTSB GAA19CA098Accident · No injuriesData collectionFinal reportCessna 170 · Riggins, IDThe pilot's improper preflight performance planning and his subsequent failure to attain sufficient speed for the airplane to climb with a tailwind.Dec 16, 2018 · N4385B · Substantial damageNTSB CEN19LA047Accident · No injuriesLimited investigationFinal reportRans S12 · McClure, OHThe cold seizure of the cylinder/piston due to the pilot’s failure to adequately warm the engine before takeoff, which resulted in a loss of engine power during a departure climb.Dec 16, 2018 · N3165V · Substantial damageNTSB GAA19CA101Accident · No injuriesData collectionFinal reportClifford E Massey AR-1 · Anahuac, TXThe pilot's improper landing flare in gusting crosswind conditions.Dec 15, 2018 · N923DJ · Substantial damageNTSB GAA19CA097Accident · No injuriesData collectionFinal reportCessna 180 · Moriarty, NMThe pilot's failure to see and avoid a parked glider while taxiing from the runway.Dec 15, 2018 · N188H · Substantial damageNTSB CEN19LA045Accident · Serious injuriesLimited investigationFinal reportBrandt Sonex · Lodi, WIThe pilot's failure to maintain proper alignment with the runway during final approach, which resulted in impact with a tree.Dec 15, 2018 · N393SX · Substantial damageNTSB GAA19CA100Accident · No injuriesData collectionFinal reportCessna A185 · Tacoma, WAThe pilot's loss of directional control during the landing roll and his subsequent overapplication of left rudder, which resulted in the right wing impacting the runway.Dec 14, 2018 · N19EC · Substantial damageNTSB ERA19FA066Accident · 1 fatalField investigationFinal reportEipper Quicksilver · Fredericksburg, VAThe pilot's exceedance of the airplane's critical angle of attack, which led to an aerodynamic stall while turning in the traffic pattern at low altitude.Dec 14, 2018 · N350FT · Substantial damageNTSB CEN19FA044Accident · 1 fatalField investigationFinal reportPiper PA24 · Valparaiso, INThe pilot's failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall and spin.Dec 13, 2018 · N6785P · DestroyedNTSB GAA19CA096Accident · No injuriesData collectionFinal reportBeech 36 · Hartford, WIThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and impact with terrain during landing in icing conditions.Dec 12, 2018 · N6650M · Substantial damageNTSB GAA19CA095Accident · No injuriesData collectionFinal reportPiper PA28 · Chino, CAThe flight instructor's failure to maintain directional control during landing.Dec 12, 2018 · N5800U · Substantial damageNTSB GAA19CA091Accident · No injuriesData collectionFinal reportZlin Z143 · Chester, CTThe pilot's loss of airplane control during the engine start.Dec 10, 2018 · N143GW · Substantial damageNTSB ERA19LA062Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Paramus, NJMaintenance personnel's improper assembly of the engine during overhaul, which resulted in lubrication restriction due to a bearing shift and the subsequent engine failure.Dec 9, 2018 · N5756W · Substantial damageNTSB GAA19CA090Accident · Minor injuriesData collectionFinal reportZenair CH 750 Cruzer · Hesperia, CAThe pilot's improper landing flare, which resulted in hard, bounced landing, runway excursion, and impact with a hangar.Dec 8, 2018 · N947DS · Substantial damageNTSB ERA19LA061Accident · Serious injuriesClass 3 · LimitedFinal reportCessna P210 · Myerstown, PAA total loss of engine power due to fuel starvation.Dec 8, 2018 · N731LT · Substantial damageNTSB DCA19IA036Incident · No injuriesClass 3 · IncidentFinal reportBoeing 737 · Burbank, CA(1) The flight crewmembers’ decision, due to plan continuation bias, to continue the approach despite indications of windshear and a higher-than-expected tailwind and (2) the flight crew’s misperception of the airplane’s touchdown point, which was farther…Dec 6, 2018 · N752SW · Minor damage