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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB WPR12LA109Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Antioch, CAThe failure of both pilots to see and avoid each other during cruise flight, which resulted in a midair collision. Contributing to the accident was the failure of air traffic control personnel to issue the helicopter pilot a prompt and appropriate alternate…NTSB WPR12CA134Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A Twin II Acro · Dillingham, HIThe student pilot’s inadequate recovery from a bounced landing.NTSB ANC12CA023Accident · No injuriesData collectionFinal reportCessna 182A · Anchorage, AKThe pilot's inadvertent landing on a frozen lake in dark night conditions.NTSB WPR12CA114Accident · No injuriesData collectionFinal reportAeronca 7BCM · Woodland, CAThe pilot did not maintain directional control during landing.NTSB ERA12CA211Accident · No injuriesData collectionFinal reportCessna 172M · Mayaquez, PRThe pilot did not maintain control of the airplane while landing in crosswind conditions.NTSB CEN12LA176Accident · No injuriesLimited investigationFinal reportAviat A-1C-200 · Bowling Green, OHThe pilot’s failure to maintain directional control during landing.NTSB CEN12LA166Accident · Serious injuriesLimited investigationFinal reportBoeing 737-832 · Detroit, MIAn in-flight encounter with forecasted turbulence, which resulted in a serious injury to a flight attendant. Contributing to the accident was the flight attendant not being seated with her seatbelt fastened when the encounter occurred.NTSB CEN12FA161Accident · 2 fatalField investigationFinal reportCessna 414A · Hayden, COThe pilot’s inadvertent stall during a missed approach. Contributing to the accident was the pilot’s operation of the airplane in forecasted icing conditions without using all of its anti-ice systems.NTSB WPR12LA110Accident · No injuriesLimited investigationFinal reportBeech C23 · Rawlins, WYThe pilot's failure to maintain airspeed during the initial climb after takeoff, which resulted in an uncontrolled descent and collision with terrain.NTSB ERA12CA190Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Swainsboro, GAThe pilot’s failure to maintain the proper glidepath during final approach in night visual meteorological conditions, which resulted in a collision with trees.NTSB ERA12CA189Accident · No injuriesData collectionFinal reportCessna 172S · Caldwell, NJThe student pilot’s loss of directional control during a crosswind landing.NTSB CEN12LA218Accident · No injuriesLimited investigationFinal reportCessna 182A · New Philadelphia, OHThe inadequate maintenance of the wheel attachment bolts, which resulted in the left wheel separating from the landing gear during landing due to ductile overstress fractures.NTSB CEN12CA160Accident · No injuriesData collectionFinal reportCessna 180 · South Fork, COThe pilot's loss of directional control while landing on a patchy snow-covered runway.NTSB WPR12LA108Accident · No injuriesLimited investigationFinal reportMooney M20J · Lewiston, CAA loss of engine power due to oil starvation as a result of improper maintenance.NTSB WPR12CA173Accident · No injuriesData collectionFinal reportLindstrand LBL180A · Temecula, CAThe pilot failed to see and avoid a set of power lines while maneuvering to a landing site.NTSB ERA12LA186Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Jasper, GAThe pilots' inadequate preflight inspection that failed to detect water-contaminated fuel, which resulted in a total loss of engine power.NTSB ERA12LA184Accident · Serious injuriesLimited investigationFinal reportMooney M20TN · Fayetteville, NCThe pilot’s failure to maintain adequate separation behind a large airplane during landing, which resulted in an encounter with wake turbulence and a loss of control.NTSB CEN12CA165Accident · No injuriesData collectionFinal reportBeech 95-B55 · Lancaster, WIThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB DCA12CA042Accident · No injuriesData collectionFinal reportEmbraer EMB120 · Iliamna, AKthe maintenance personnel's failure to install the cotter pins that secured castellated nuts on the left elevator vertical hinge bolts, which resulted in the left elevator partially detaching in flight. Contributing to the accident was the failure of…NTSB WPR12GA106Accident · 1 fatalFinal reportBell 407 · Moran Junction, WYThe pilot’s failure to maintain yaw control while hovering at high density altitude, which resulted in a loss of tail rotor effectiveness.NTSB WPR12FA105Accident · 3 fatalField investigationFinal reportCessna 172S · North Bend, WAThe pilot's physical impairment due to alcohol, which adversely affected his ability to operate the airplane and to maintain clearance from mountainous terrain while operating in dark night conditions.NTSB ERA12CA182Accident · Minor injuriesData collectionFinal reportBeech 58 · South Charleston, WVThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.NTSB WPR12LA104Accident · No injuriesLimited investigationFinal reportBeech G18 · Hollister, CAThe pilot’s failure to maintain adequate airspeed during the initial climb, which resulted in an aerodynamic stall and a subsequent hard landing, loss of directional control, and ground loop.NTSB WPR12CA112Accident · No injuriesData collectionFinal reportRockwell International S-2R · Yellow Pine, IDThe pilot did not maintain directional control while landing on a snow-contaminated runway.NTSB ERA12LA180Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Amory, MSThe pilot's inadequate preflight and in-flight planning and decision-making, including his inadequate weather evaluation and his delayed diversion to a closer airport, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN12FA158Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Osborn, MOThe pilot’s decision to conduct low-level passes above a residence and his failure to maintain sufficient altitude.NTSB ERA12CA213Accident · No injuriesData collectionFinal reportZenair CH 2000 · Warrenton, VAThe student pilot's failure to follow instruction and to relinquish control of the airplane to the flight instructor in a timely manner, which resulted in a runway excursion.NTSB ERA12CA179Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · N. Charleston, SCThe flight instructor’s failure to apply power during a practice autorotation in order to arrest a high rate of descent, which resulted in an in-flight collision with terrain.NTSB ENG12IA012Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-10-30F · Portland, ORThe fracture of the fan mid shaft due to a stress corrosion cracking initiated by local regions of corrosion pitting, which resulted from oil migration within the shaft and its subsequent degradation.NTSB WPR12CA102Accident · Minor injuriesData collectionFinal reportPiper PA-18-135 · Concrete, WAThe pilot did not attain and maintain sufficient altitude to clear terrain while maneuvering.NTSB ERA12CA177Accident · No injuriesData collectionFinal reportRockwell International 114 · Hilton Head, SCThe pilot’s failure to maintain directional control of the airplane while landing with a crosswind.NTSB WPR12CA101Accident · No injuriesData collectionFinal reportLearjet 31A · Wheatland, WYThe flight crew’s loss of directional control during landing on an ice- and water-contaminated runway, which resulted in a runway excursion.NTSB WPR12CA100Accident · Minor injuriesData collectionFinal reportSchweizer 269C · Las Vegas, NVThe pilot's inadequate compensation for the known wind conditions during a hovering maneuver, which resulted in a loss of tail rotor effectiveness and directional control.NTSB ERA12CA178Accident · No injuriesData collectionFinal reportCessna 152 · Miami, FLThe student pilot's improper flare and recovery from a bounced landing.NTSB CEN12LA153Accident · Minor injuriesLimited investigationFinal reportSocata TBM 700 · Madison, WIThe pilot’s failure to ensure that ice and snow were removed from the airplane’s surfaces during the preflight inspection, which resulted in an inadvertent aerodynamic stall after takeoff and loss of control of the airplane.NTSB CEN12FA154Accident · 1 fatalField investigationFinal reportCessna 172N · Floresville, TXThe medical incapacitation of the pilot due to a sudden cardiac arrhythmia or acute myocardial infarction.NTSB ANC12CA022Accident · No injuriesData collectionFinal reportCessna 172I · McCarthy, AKThe pilot lost directional control during landing.NTSB WPR12FA098Accident · 2 fatalField investigationFinal reportCessna 210 · Morgan, UTThe non-instrument-rated pilot’s poor planning and continued visual flight rules flight into instrument meteorological conditions and failure to maintain clearance from mountainous terrain.NTSB ERA12FA175Accident · 1 fatalField investigationFinal reportCessna T182T · Lebanon, NHThe pilot’s failure to maintain airspeed during a return to the airport after takeoff, which resulted in an aerodynamic stall and loss of airplane control.NTSB CEN12FA152Accident · 1 fatalField investigationFinal reportVarga 2150A · Frankston, TXThe loss of engine power due to carburetor ice, which resulted in the pilot ditching the airplane into the lake. Contributing to the accident was the pilot’s decision not to apply carburetor heat.NTSB CEN12CA159Accident · No injuriesData collectionFinal reportMaule MX-7-235 · Tea, SDThe pilot did not maintain directional control of the airplane during a crosswind landing.NTSB ERA12CA173Accident · No injuriesData collectionFinal reportAeropro CZ Eurofox LSA · Winter Haven, FLThe flight instructor’s delayed remedial action to prevent the airplane from hitting the hangar door. Contributing to the accident was the student pilot's misuse of the airplane's throttle, and his incorrect use of the wheel brakes.NTSB ERA12CA172Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Greenville, SCThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.NTSB WPR12LA093Accident · 1 fatalLimited investigationFinal reportCessna 172N · Fresno, CAThe non-certificated pilot’s failure to maintain clearance from power lines. Contributing to the accident was the pilot’s impairment due to performance-impairing drugs.NTSB ERA12LA188Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Culpeper, VAThe pilot's failure to use the manufacturer's checklist to troubleshoot the perceived malfunction and thereby ensure the position of the landing gear before landing. The reason the landing gear were not down and locked could not be determined, as no…NTSB ERA12LA171Accident · Serious injuriesLimited investigationFinal reportMoore Byron J Zealot · Minneola, FLThe pilot's failure to maintain adequate airspeed on the base leg for landing, which resulted in an aerodynamic stall and loss of airplane control.NTSB WPR12CA103Accident · No injuriesData collectionFinal reportRockwell International S-2R · Yellow Pine, IDThe pilot did not reduce the airplane’s descent rate prior to the landing flare/touchdown, which resulted in a hard landing.NTSB CEN12CA148Accident · No injuriesData collectionFinal reportPiper PA-18 · Thedford, NEThe pilot did not maintain directional control during landing, which resulted in a runway excursion.NTSB WPR12LA092Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Kalispell, MTThe partial loss of engine power due to magneto malfunction. Contributing to the accident was the lack of adherence to the manufacturer’s recommended magneto overhaul schedule.NTSB WPR12FA091Accident · 2 fatalField investigationFinal reportCessna T206H · Show Low, AZThe pilot’s encounter with low clouds/low visibility conditions during the initial climb, which resulted in spatial disorientation and loss of airplane control.