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 ERA12CA495Accident · No injuriesData collectionFinal reportPiper PA-25-260 · Alexander, NYThe pilot's inadequate visual lookout and failure to maintain altitude during aerial application, which resulted in controlled flight into terrain.Aug 2, 2012 · N6802L · Substantial damageNTSB ANC12FA083Accident · 1 fatalField investigationFinal reportPiper PA-32-301 · Hoonah, AKThe pilot's failure to maintain clearance from trees and terrain while in cruise flight in marginal visual meteorological conditions.Aug 2, 2012 · N8200M · DestroyedNTSB ERA12LA494Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Titusville, FLInadequate maintenance servicing and inspection of the nose landing gear, which resulted in the failure of the nose landing gear to lock and its subsequent collapse during landing.Aug 1, 2012 · N740FT · Substantial damageNTSB ERA12LA493Accident · No injuriesLimited investigationFinal reportSikorsky S-58JT · Middletown, DEThe pilot's failure to recognize that the helicopter was experiencing tail rotor dynamic instability and to take immediate corrective actions during an external load lift, which resulted in the failure of a tail rotor blade.Aug 1, 2012 · N126GW · Substantial damageNTSB ERA12FA491Accident · 1 fatalField investigationFinal reportSilvaire Luscombe 8A · St. Petersburg, FLThe flight instructor’s and the pilot’s failure to maintain airspeed after a partial loss of engine power after takeoff for reasons that could not be determined during postaccident examination, which resulted in an aerodynamic stall and loss of airplane…Aug 1, 2012 · N2761K · Substantial damageNTSB ERA12CA490Accident · No injuriesData collectionFinal reportAeronca 7AC · Winter Haven, FLThe student pilot’s failure to maintain directional control during the landing roll.Aug 1, 2012 · N1060E · Substantial damageNTSB CEN12LA522Accident · No injuriesLimited investigationFinal reportPiper PA18 · Peyton, COThe pilot's failure to maintain airplane control during taxi in gusting wind conditions.Aug 1, 2012 · N7808Z · Substantial damageNTSB CEN12LA501Accident · Serious injuriesLimited investigationFinal reportBeech H35 · Holly Lake Ranch, TXThe incomplete maintenance performed by maintenance personnel, which resulted in a total loss of engine power.Aug 1, 2012 · N4684D · Substantial damageNTSB CEN12LA500Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Newellton, LAThe pilot's inadequate takeoff planning and his use of an improper flap setting, which resulted in a runway excursion and collision with terrain during takeoff.Aug 1, 2012 · N5128U · Substantial damageNTSB CEN12CA510Accident · No injuriesData collectionFinal reportCessna 172S · Oshkosh, WIThe flight instructor’s loss of directional control during landing, which resulted in a collision with a runway light.Aug 1, 2012 · N462TR · Substantial damageNTSB OPS12IA849Incident · No injuriesIncident investigationFinal reportArlington, VAA hearback/readback error on the part of the tower traffic management coordinator, who did not understand the request being made by the approach control area supervisor and then communicated that misunderstanding to the local controllers. Contributing to the…Jul 31, 2012 · No damageNTSB CEN12LA507Accident · No injuriesLimited investigationFinal reportCessna 150M · Cottage Grove, WIThe pilot's decision to land on a runway with significant overgrown vegetation along the edges and his landing, which was left of the centerline.Jul 31, 2012 · N45080 · Substantial damageNTSB CEN12CA509Accident · No injuriesData collectionFinal reportCessna 182Q · Three Lakes, WIThe pilot's excessive touchdown speed, which resulted in a bounced landing. Contributing to the accident was the pilot's lack of recent experience in flying light airplanes.Jul 31, 2012 · N1DV · Substantial damageNTSB ANC12LA080Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Gakona, AKThe pilot's improper fuel planning, which resulted in a loss of engine power due to fuel exhaustion.Jul 31, 2012 · N7150E · Substantial damageNTSB ANC12CA082Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Wainwright, AKThe failure of ground personnel to ensure the helicopter was serviced with the proper fuel. Contributing to the accident was the pilot's failure to monitor the fueling process.Jul 31, 2012 · N74496 · Substantial damageNTSB WPR12CA336Accident · No injuriesData collectionFinal reportPiper PA28-150 · Yellow Pine, IDThe pilot's failure to attain and maintain an appropriate glide path, failure to perform a go-around, and failure to maintain directional control during the landing roll.Jul 30, 2012 · N5818W · Substantial damageNTSB CEN12LA497Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Big Springs, NEThe total loss of engine power as a result of the pilot inadvertently shutting the engine off. Contributing to the accident was the modification to the engine control layout.Jul 30, 2012 · N6676Q · Substantial damageNTSB CEN12LA493Accident · No injuriesLimited investigationFinal reportCessna 182G · Montrose, COThe pilot's improper landing flare and inadequate recovery from a bounced landing.Jul 30, 2012 · N3198S · Substantial damageNTSB CEN12CA499Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Hutchinson, KSThe pilot’s loss of directional control during the landing roll.Jul 30, 2012 · N460CT · Substantial damageNTSB WPR12CA333Accident · No injuriesData collectionFinal reportCessna 170A · Ellensburg, WAThe pilot’s loss of directional control during the landing roll.Jul 29, 2012 · N4089A · Substantial damageNTSB CEN12LA512Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Bragg City, MOThe pilot's failure to properly tighten the b-nut from the engine-driven fuel pump to the fuel-metering unit during maintenance, which resulted in a total loss of engine power due to fuel starvation.Jul 29, 2012 · N8121Y · Substantial damageNTSB CEN12LA495Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Lakeview, ARThe pilot’s loss of control during the takeoff roll for reasons that could not be determined because postaccident examination of the airplane did not reveal any anomalies that would have precluded normal operation.Jul 29, 2012 · N462CP · Substantial damageNTSB CEN12LA490Accident · Serious injuriesLimited investigationFinal reportSmith Applebay Zuni II · Gregory, MIThe glider pilot’s failure to maintain sufficient altitude and airspeed while turning to the base leg of the traffic pattern, which resulted in a stall/spin and impact with trees and terrain.Jul 29, 2012 · N1ZV · Substantial damageNTSB CEN12CA503Accident · No injuriesData collectionFinal reportPiper PA-16 · Keokuk, IAThe pilot’s loss of directional control during the landing roll in a variable crosswind, which resulted in a runway excursion.Jul 29, 2012 · N6834K · Substantial damageNTSB ANC12IA085Incident · No injuriesIncident investigationFinal reportBellanca 8KCAB · Homer, AKThe failure of the left main landing gear leg due to fatigue. Contributing to the incident was maintenance personnel's failure to completely remove all corrosion before repainting the gear leg.Jul 29, 2012 · N5026B · Minor damageNTSB WPR12FA332Accident · No injuriesField investigationFinal reportPiaggio P180 · Henderson, NVThe failure of maintenance personnel to properly torque the elevator attachment hardware in accordance with the maintenance manual, which led to the detachment of the elevator. Contributing to the accident were maintenance personnel's failure to identify the…Jul 28, 2012 · N146SL · Substantial damageNTSB WPR12CA337Accident · Minor injuriesData collectionFinal reportCessna 172 · Grand Canyon, AZThe pilot’s improper flare and inadequate recovery from a bounced landing.Jul 28, 2012 · N8100B · Substantial damageNTSB WPR12CA330Accident · No injuriesData collectionFinal reportAlon A2 · Compton, CAThe pilot's failure to maintain directional control during landing.Jul 28, 2012 · N5486E · Substantial damageNTSB ERA12LA489Accident · No injuriesLimited investigationFinal reportBeech A36TC · Fayetteville, NCThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Jul 28, 2012 · N6672X · Substantial damageNTSB CEN12LA549Accident · No injuriesLimited investigationFinal reportCessna 182D · Rose Hill, KSThe inadvertent deployment of a skydiver's parachute, which struck the right horizontal stabilizer.Jul 28, 2012 · N8882X · Substantial damageNTSB ERA12LA503Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Homerville, GAThe loss of engine power due to debris within the engine-driven fuel pump.Jul 27, 2012 · N1572S · Substantial damageNTSB ERA12LA486Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Blacksburg, VAThe pilot’s inadequate preflight planning and improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.Jul 27, 2012 · N6248P · Substantial damageNTSB CEN12LA488Accident · 1 fatalLimited investigationFinal reportJoseph C. Andrews, Jr. Vans · Valentine, NEThe RV-6 pilot's failure to monitor the location of the RV-4, resulting in the on-ground collision. Contributing to the accident was the RV-6 pilot not ensuring proper separation from the RV-4 and his expectation that the pilot of RV-4 would roll out to the…Jul 27, 2012 · N122JA · 2 aircraft · Substantial damageNTSB CEN12FA487Accident · No injuriesField investigationFinal reportMooney M20TN · Adrian, MIAn initial nose-pitch-up event and out-of-trim condition, the reason for which could not be determined because the examinations of the airplane did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the…Jul 27, 2012 · N411JL · Substantial damageNTSB CEN12CA484Accident · Serious injuriesData collectionFinal reportBell 47G-2A · Austin, INThe pilot did not maintain clearance from terrain during a low-level aerial application flight and lost control of the helicopter.Jul 27, 2012 · N652HA · Substantial damageNTSB ERA12LA482Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Green Creek, NJThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel starvation while maneuvering.Jul 26, 2012 · N4361M · Substantial damageNTSB ERA12FA483Accident · 1 fatalField investigationFinal reportCessna 172P · Plainville, CTThe pilot's failure to maintain the proper glidepath during final approach in visual meteorological conditions, resulting in collision with a berm.Jul 26, 2012 · N64182 · Substantial damageNTSB ERA12CA485Accident · No injuriesData collectionFinal reportBayliss Milton A III X-AIR · Houlton, METhe pilot's failure to maintain directional control during the landing flare in a gusting crosswind, which resulted in a runway excursion.Jul 26, 2012 · N8076E · Substantial damageNTSB WPR12CA345Accident · No injuriesData collectionFinal reportCessna 172N · Ashland, ORThe student pilot's improper flare, which resulted in a hard landing.Jul 25, 2012 · N738AJ · Substantial damageNTSB ERA12FA484Accident · 1 fatalField investigationFinal reportCessna 172M · San Juan, PRMaintenance personnel’s improper lubrication of the right direct aileron control cable and failure to detect the severe corrosion of the cable during a maintenance inspection, which resulted in the in-flight failure of the cable, the pilot’s subsequent…Jul 25, 2012 · N73115 · Substantial damageNTSB ERA12CA492Accident · No injuriesData collectionFinal reportFairchild M-62A · Albion, NYThe pilot’s failure to maintain directional control while taking off in gusting wind conditions.Jul 25, 2012 · N53953 · Substantial damageNTSB CEN12LA480Accident · Minor injuriesLimited investigationFinal reportScotts-Bell 47 47G-2A · Akeley, MNThe pilot’s failure to maintain helicopter control during low altitude agricultural operations.Jul 25, 2012 · N73252 · Substantial damageNTSB CEN12LA476Accident · No injuriesLimited investigationFinal reportFlight Design Ctls · Conway, ARThe pilot's improper landing flare, which resulted in a hard landing and overstress failure of the right main landing gear.Jul 25, 2012 · N930SA · Substantial damageNTSB CEN12CA486Accident · No injuriesData collectionFinal reportMooney M20M · Heber Springs, ARThe pilot's improper flare, which led to a bounced landing and a subsequent loss of control.Jul 25, 2012 · N9145L · Substantial damageNTSB CEN12CA482Accident · No injuriesData collectionFinal reportNelson Miles Sky Star Kitfox · Weatherford, TXThe pilot's failure to maintain directional control during the landing flare. Contributing to the accident was the pilot’s delay in aborting the landing.Jul 25, 2012 · N4454U · Substantial damageNTSB WPR12TA323Accident · No injuriesFinal reportAero Commander 500 S · Elko, NVA loss of power due to fuel exhaustion. Contributing to the accident were the pilot's failure to comply with required fueling procedures and the pilot's poor decision-making in not monitoring his fuel gauge and turning back when it reached minimum fuel.Jul 24, 2012 · N535SA · Substantial damageNTSB ERA12LA477Accident · No injuriesLimited investigationFinal reportHughes 269C · St. Petersburg, FLThe pilot's failure to assure that the lateral friction control was released prior to flight.Jul 24, 2012 · N9679F · Substantial damageNTSB ERA12CA476Accident · No injuriesData collectionFinal reportMooney M20TN · Hilton Head, SCThe pilot’s failure to maintain directional control while landing in a crosswind.Jul 24, 2012 · N212D · Substantial damageNTSB CEN12LA473Accident · No injuriesLimited investigationFinal reportCessna TR182 · Steamboat Springs, COThe pilot's failure to extend the landing gear before landing.Jul 24, 2012 · N73VX · Substantial damageNTSB CEN12CA474Accident · No injuriesData collectionFinal reportEurocopter Deutschland MBB-BK 117 C-2 · Houston, TXThe pilot’s inadequate preflight inspection, which failed to detect the unsecured cowling latches and resulted in the in-flight opening of an engine cowling.Jul 24, 2012 · N455MH · Substantial damage