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 CEN11CA203Accident · No injuriesData collectionFinal reportCessna 195A · Hannibal, MOThe pilot's inability to maintain control during landing due to seized main landing gear wheels, which caused the airplane to nose over.Feb 24, 2011 · N9325A · Substantial damageNTSB ERA11LA156Accident · No injuriesLimited investigationFinal reportCessna 172G · Clarksville, FLA loss of engine power due to fuel starvation as a result of the owner's improper maintenance of the fuel selector valve, which resulted in a lack of fuel supply from the right fuel tank.Feb 23, 2011 · N3740L · Substantial damageNTSB ANC11CA013Accident · No injuriesData collectionFinal reportPiper PA-18 · Sterling, AKThe airplane owner improper fabrication of a fuel line, and subsequent inadequate inspection by an aviation mechanic, resulting in a loss of engine power.Feb 23, 2011 · N623MP · Substantial damageNTSB WPR11CA142Accident · No injuriesData collectionFinal reportPiper PA-31P-350 · North Bend, ORThe pilot's failure to lower the landing gear while on approach to landing. Contributing to the accident was the pilot's failure to follow a written checklist during the approach portion of the flight.Feb 22, 2011 · N9237Y · Substantial damageNTSB CEN11CA208Accident · No injuriesData collectionFinal reportBeech 58 · Prospect Heights, ILThe pilot's inadequate flare, which resulted in a hard landing.Feb 22, 2011 · N12LK · Substantial damageNTSB CEN11IA198Incident · No injuriesIncident investigationFinal reportBoeing 737-823 · Southlake, TXThe tractor driver’s failure to confirm that the tow bar head/handle was secured correctly to the airplane.Feb 21, 2011 · N945AN · Minor damageNTSB CEN11CA197Accident · No injuriesData collectionFinal reportPiper PA-32R-301 · Holdenville, OKThe pilot’s decision to land with a tailwind and his delay in executing a go around.Feb 20, 2011 · N8310L · Substantial damageNTSB ERA11FA151Accident · 1 fatalField investigationFinal reportCessna 150E · Ware Shoals, SCThe non-certificated pilot's impairment due to alcohol and a sedating antihistamine, which resulted in his failure to maintain airspeed and the subsequent aerodynamic stall and ground impact.Feb 19, 2011 · N3022J · Substantial damageNTSB ERA11LA154Accident · No injuriesLimited investigationFinal reportCessna 177B · Reading, PAInadequate maintenance inspection of the airplane which resulted in a shift of the shock mounted portion of the pilot's instrument panel, causing an interference of the pitch control during takeoff.Feb 18, 2011 · N11625 · Substantial damageNTSB CEN11FA195Accident · 2 fatalField investigationFinal reportCessna 182P · Levelland, TXThe pilot’s failure to maintain control of the airplane during a landing and subsequent go-around with a crosswind.Feb 18, 2011 · N325LA · Substantial damageNTSB CEN11CA196Accident · Serious injuriesData collectionFinal reportMooney M20K · Urbana, ILThe pilot's failure to maintain aircraft control during the go-around.Feb 17, 2011 · N262CP · Substantial damageNTSB WPR11LA136Accident · Minor injuriesLimited investigationFinal reportPiper PA18 · Twin Falls, IDThe pilot’s failure to compensate for the wind, which resulted in the airplane being blown over after completion of the landing roll.Feb 16, 2011 · N7153Z · Substantial damageNTSB ERA11FA146Accident · 2 fatalField investigationFinal reportCessna 172S · New Smyrna Beach, FLThe flight instructor's failure to recognize or implement adequate remedial action to counter the effects of spatial disorientation. Contributing to the accident was the spatial disorientation experienced by one or both pilots.Feb 16, 2011 · N6345L · Substantial damageNTSB WPR11FA138Accident · 2 fatalField investigationFinal reportAirBorne WindSport Edge XT-912-L · Hanapepe, HIThe flight instructor did not maintain aircraft control while maneuvering at low altitude. Contributing to the accident was the inadvertent application of the choke, which resulted in a momentary interruption of engine power.Feb 15, 2011 · N29EP · Substantial damageNTSB ERA11CA147Accident · No injuriesData collectionFinal reportCessna 172S · Daytona Beach, FLThe pilot's inadequate flare that resulted in a hard landing.Feb 15, 2011 · N378FA · Substantial damageNTSB CEN11LA194Accident · 1 fatalLimited investigationFinal reportTaylorcraft DCO-65 · Americus, INThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.Feb 15, 2011 · N46089 · Substantial damageNTSB CEN11LA192Accident · No injuriesLimited investigationFinal reportBeech E-90 · Des Moines, IAThe improper installation of the right aileron by maintenance personnel.Feb 15, 2011 · N51DN · Substantial damageNTSB WPR11LA137Accident · Serious injuriesLimited investigationFinal reportAmerican Champion 8GCBC · Soda Springs, IDThe pilot's failure to maintain clearance from power lines while maneuvering at a low altitude in a valley.Feb 14, 2011 · N885AC · Substantial damageNTSB ERA11CA144Accident · No injuriesData collectionFinal reportCessna 172H · Plattsburgh, NYThe student pilot's loss of directional control during the landing flare in gusting wind conditions and the certified flight instructor's delayed remedial action.Feb 14, 2011 · N2593L · Substantial damageNTSB CEN11FA193Accident · No injuriesField investigationFinal reportGulfstream Aerospace GV-SP · Appleton, WIThe pilot flying's (PF) decision to land on a shorter-than-recommended runway with a known left hydraulic system failure rather than go around as suggested by the pilot-not-flying, his failure to immediately apply emergency brakes following the detection of…Feb 14, 2011 · N535GA · Substantial damageNTSB CEN11CA185Accident · No injuriesData collectionFinal reportPiper PA-28RT-201 · Danville, INThe pilot's failure to extend the landing gear prior to touchdown.Feb 14, 2011 · N2878N · Substantial damageNTSB WPR11LA133Accident · 1 fatalLimited investigationFinal reportBuckeye Breeze LX · Bullfrog, UTThe pilot’s loss of control while maneuvering to land at an off-airport site.Feb 13, 2011 · N75752 · Substantial damageNTSB WPR11CA152Accident · No injuriesData collectionFinal reportCessna 172 · Lancaster, CAThe student pilot's improper flare which resulted in a hard landing. Contributing to the accident was the certified flight instructor's delayed remedial action.Feb 13, 2011 · N31FC · Substantial damageNTSB ERA11LA142Accident · No injuriesLimited investigationFinal reportKennedy Michael M Lancair 320 · Dawsonville, GAThe pilot’s inadequate preflight inspection and failure to detect water-contaminated fuel, which resulted in a loss of engine power.Feb 13, 2011 · N351E · Substantial damageNTSB WPR11CA134Accident · No injuriesData collectionFinal reportBal-Air Inc/Wayne John K Christen Eagle · Groveland, CAThe pilot's failure to compensate for crosswind conditions and maintain directional control during the landing roll, which resulted in a runway excursion.Feb 12, 2011 · N17AJ · Substantial damageNTSB CEN11LA188Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Springdale, ARThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Feb 12, 2011 · N3257J · Substantial damageNTSB CEN11LA183Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Minneapolis, MNThe pilot's loss of directional control during the landing.Feb 12, 2011 · N536PU · Substantial damageNTSB CEN11CA184Accident · No injuriesData collectionFinal reportCessna 172N · Poplar Grove, ILThe student pilot's failure to maintain directional control of the airplane during the takeoff.Feb 12, 2011 · N733TM · Substantial damageNTSB WPR11CA132Accident · Minor injuriesData collectionFinal reportCessna 170A · Baker Lake, WAThe pilot's encounter with soft terrain during an attempted takeoff from a dry lake bed.Feb 11, 2011 · N9768A · Substantial damageNTSB WPR11LA131Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Novato, CAThe pilot's use of a non-vented fuel cap, which resulted in a total loss of engine power due to fuel starvation.Feb 10, 2011 · N2659E · Substantial damageNTSB ERA11LA139Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Lincoln Park, NJThe pilot’s inadequate preflight inspection (removal of water contamination from the fuel system), which resulted in a total loss of engine power.Feb 10, 2011 · N25HD · Substantial damageNTSB WPR11CA130Accident · Minor injuriesData collectionFinal reportAllardyce Michael Glastar · Wilsonville, ORThe pilot's failure to raise the landing gear wheels prior to landing in water, resulting in a nose over.Feb 9, 2011 · N238MA · Substantial damageNTSB CEN11IA179Incident · No injuriesIncident investigationFinal reportCessna 210N · Columbia, MOThe pilot did not extend the landing gear before touchdown due to his distraction during the landing approach and his not using a landing checklist.Feb 8, 2011 · N92MP · Minor damageNTSB CEN11CA181Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Lansing, ILThe pilot’s loss of directional control during the landing.Feb 8, 2011 · N4643R · Substantial damageNTSB WPR11FA125Accident · Serious injuriesField investigationFinal reportBeech 95-B55 (T42A) · San Bernardino, CAThe pilot did not recognize the loss of power in the right engine and did not execute the proper procedures for a go-around with one engine inoperative, likely due to increased workload. Contributing to the accident was the pilot's improper in-flight fuel…Feb 7, 2011 · N225DH · Substantial damageNTSB ERA11CA138Accident · No injuriesData collectionFinal reportCessna 172 · Meriden, CTThe student pilot's loss of directional control during the landing rollout, resulting in a runway excursion.Feb 7, 2011 · N9622Q · Substantial damageNTSB CEN11LA178Accident · No injuriesLimited investigationFinal reportBeech A36 · Danville, ILThe pilot's failure to maintain directional control during the landing roll.Feb 7, 2011 · N6XZ · Substantial damageNTSB WPR11CA123Accident · Minor injuriesData collectionFinal reportBeech 95-B55 (T42A) · Van Nuys, CAThe pilot's failure to turn off the engine magnetos and properly secure the airplane prior to rotating the propeller by hand, resulting in inadvertent movement of the airplane and collision with a building.Feb 6, 2011 · N2074L · Substantial damageNTSB ERA11LA135Accident · Serious injuriesLimited investigationFinal reportBelcher William B II Firestar · West Blocton, ALThe student pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.Feb 6, 2011 · N43341 · Substantial damageNTSB CEN11CA211Accident · Minor injuriesData collectionFinal reportPiper PA-34-220T · Bogalusa, LAThe pilot’s inadequate flare after encountering a gust of wind on landing.Feb 6, 2011 · N80311 · Substantial damageNTSB WPR11CA128Accident · No injuriesData collectionFinal reportSchweizer G-164B · Buttonwillow, CAThe pilot's failure to maintain clearance from an irrigation vent pipe.Feb 5, 2011 · N6725K · Substantial damageNTSB WPR11CA126Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Minden, NVThe pilot's loss of directional control during landing.Feb 5, 2011 · N2603Y · Substantial damageNTSB ERA11CA134Accident · Serious injuriesData collectionFinal reportPiper PA-12 · Sebago Lake, METhe pilot’s initiation of a right turn with insufficient altitude remaining during an aborted landing resulting in a collision with the landing surface.Feb 5, 2011 · N3806M · Substantial damageNTSB CEN11CA221Accident · No injuriesData collectionFinal reportCessna 150L · Gonzales, LAThe flight instructor's failure to monitor the available fuel supply, which resulted in a loss of engine power due to fuel exhaustion.Feb 5, 2011 · N11790 · Substantial damageNTSB WPR11LA122Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas Helicopters 369E (MD500E) · Elverta, CAThe pilot did not maintain rotor blade clearance from an installation rope while maneuvering to install power lines.Feb 4, 2011 · N416WC · Substantial damageNTSB WPR11CA121Accident · No injuriesData collectionFinal reportRobinson R44 · Ogden, UTThe certified flight instructor’s failure to maintain adequate main rotor blade rpm during a practice autorotation, resulting in a hard landing and rollover.Feb 4, 2011 · N441TB · Substantial damageNTSB WPR11FA120Accident · 1 fatalField investigationFinal reportAeronca O-58C · San Luis Obispo, CAThe pilot’s delay in using carburetor heat, which resulted in a loss of engine power due to an encounter with carburetor icing conditions.Feb 3, 2011 · N47503 · Substantial damageNTSB ERA11FA133Accident · 2 fatalField investigationFinal reportPotez-Air Fouga CM 170 Magister · Kissimmee, FLThe pilot/mechanic's improper decision to continue a tight-turning landing pattern after a loss of hydraulic pressure, and his subsequent failure to maintain adequate airspeed during that pattern, which resulted in an accelerated maneuver stall. Contributing…Feb 2, 2011 · N415FM · Substantial damageNTSB WPR11CA118Accident · Serious injuriesData collectionFinal reportCessna 182 · Eastsound, WAThe pilot’s failure to properly secure the airplane prior to rotating the propeller by hand, resulting in inadvertent movement of the airplane and collision with a building.Feb 1, 2011 · N2718R · Substantial damageNTSB OPS11IA271Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Dayton, OHThe pilots' lack of consideration for developing and known weather conditions en route to and at the destination airport, resulting in a runway excursion and subsequent incursion.Feb 1, 2011 · N13964 · Minor damage