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 CEN12FA628Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Bullard, TXThe pilot's maneuver, which exceeded the airplane's structural limit and resulted in an in-flight breakup.Sep 12, 2012 · N4842P · Substantial damageNTSB CEN12LA630Accident · No injuriesLimited investigationFinal reportHalderman, Floyd G. RV-6A · Eldon, MOThe pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power.Sep 11, 2012 · N464EH · Substantial damageNTSB CEN12CA644Accident · No injuriesData collectionFinal reportCessna 421C · Kenedy, TXThe pilot’s improper flare, which resulted in a hard landing and subsequent collapse of the landing gear.Sep 11, 2012 · N5534G · Substantial damageNTSB WPR12CA412Accident · No injuriesData collectionFinal reportGrob-Werke G 120A · Mobile, AZThe student pilot’s failure to maintain directional control of the airplane during the takeoff roll and the subsequent aborted takeoff in a gusting crosswind.Sep 10, 2012 · N863AF · Substantial damageNTSB ERA12IA559Incident · No injuriesIncident investigationFinal reportCessna 402B · Opa-Locka, FLThe pilot’s turning the airplane too sharply while exiting the runway, which resulted in the failure of the right main landing gear bellcrank due to an overstress fracture.Sep 10, 2012 · N218LG · Minor damageNTSB CEN12FA621Accident · 2 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Houston, TXThe pilot's failure to maintain control of the helicopter after a loss of engine power. The reason for the loss of engine power could not be determined because examination did not reveal any anomalies that would have precluded operation.Sep 10, 2012 · N281RG · Substantial damageNTSB CEN12FA619Accident · 1 fatalField investigationFinal reportWiggins AIR Boss · Lansing, ILThe pilot's failure to obtain adequate familiarization with gyroplane operations before attempting a flight test of the recently completed gyroplane, which resulted in his failure to maintain control during the accident flight.Sep 10, 2012 · N717EW · DestroyedNTSB WPR12LA410Accident · 1 fatalLimited investigationFinal reportSchoepflin DA-4-550 · Viola, IDThe pilot's failure to maintain airplane control while maneuvering, resulting in an aerodynamic stall/spin with insufficient altitude to recover.Sep 9, 2012 · N550YS · Substantial damageNTSB ERA12LA557Accident · No injuriesLimited investigationFinal reportPiper PA-31-325 · Washington, PAThe airplane’s encounter with a flock of geese during takeoff, which resulted in the airplane’s hard impact with the runway while the pilot maneuvered in an attempt to avoid the geese.Sep 9, 2012 · N3591P · Substantial damageNTSB ERA12LA555Accident · Serious injuriesLimited investigationFinal reportPitcairn PA-4 · Rawlings, MDA total loss of engine power due to fuel starvation, which resulted from a fuel outlet in the fuel tank that was blocked by peeled debris from a previously approved fuel tank sealer.Sep 9, 2012 · N3261 · Substantial damageNTSB CEN12FA617Accident · 1 fatalField investigationFinal reportBeech A36 · Kansasville, WIIn-flight loss of control for reasons that could not be determined because postaccident examination of the pilot and testing of the airplane did not reveal any anomalies that would have led to the loss of control.Sep 9, 2012 · N3224G · Substantial damageNTSB CEN12CA625Accident · No injuriesData collectionFinal reportBeech 35 · Geary, OKThe student pilot failed to maintain control of the airplane during a forced landing attempt which resulted in an aerodynamic stall. Contributing to the accident was the instructor pilot's delay in taking control of the airplane and the loss of engine power…Sep 9, 2012 · N3014V · Substantial damageNTSB CEN12CA620Accident · No injuriesData collectionFinal reportCessna 172H · Phillipsburg, OHThe pilot’s improper flare, which resulted in a hard landing.Sep 9, 2012 · N2484L · Substantial damageNTSB ANC12CA104Accident · No injuriesData collectionFinal reportStinson 108-2 · Nikiski, AKThe pilot's selection of an unsuitable landing surface, which resulted in a loss of control during the landing roll.Sep 9, 2012 · N9723K · Substantial damageNTSB WPR12LA407Accident · 1 fatalLimited investigationFinal reportMoore Edward R MXS · Borrego Springs, CAThe pilot’s inability to maintain control of the airplane following the loss of aileron and elevator control due to the forward flight control torque tube assembly’s detachment from the forward bearing. Contributing to the accident was the inadequate…Sep 8, 2012 · N21MX · Substantial damageNTSB WPR12CA415Accident · No injuriesData collectionFinal reportBeech V35B · Elko, NVThe pilot's failure to extend the landing gear during the aborted takeoff. Contributing to the accident was the pilot's failure to perform a thorough preflight inspection.Sep 8, 2012 · N1129T · Substantial damageNTSB CEN12FA616Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Kingsland, TXThe pilot’s failure to maintain adequate airspeed following a partial loss of engine power resulting from an engine intake valve that became stuck open. Contributing to the accident was the pilot’s decision to operate the airplane when a required maintenance…Sep 8, 2012 · N70108 · Substantial damageNTSB CEN12CA618Accident · No injuriesData collectionFinal reportBeech V35 · Decatur, TXThe pilot's inattention during the landing roll, which resulted in retraction of the landing gear instead of the flaps.Sep 8, 2012 · N149G · Substantial damageNTSB WPR12CA405Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Lake Newman, WAThe flight instructor's failure to maintain clearance from terrain while correcting for the student pilot's failure to maintain directional control of the helicopter.Sep 7, 2012 · N212SH · Substantial damageNTSB WPR12CA404Accident · Minor injuriesData collectionFinal reportKorrison Tom Sparrow Hawk · Spanish Fork, UTThe pilot's failure to maintain directional control of the gyroplane during an aborted takeoff.Sep 7, 2012 · N51140 · Substantial damageNTSB WPR12CA403Accident · Minor injuriesData collectionFinal reportAyres S2R-R1340 · Brawley, CAThe pilot's decision to attempt to takeoff in high temperatures with a tailwind. Contributing to the accident was the sun glare.Sep 7, 2012 · N4020A · Substantial damageNTSB ERA12CA553Accident · No injuriesData collectionFinal reportCessna 182T · Marion, SCThe pilot's improper landing flare, which resulted in a hard landing.Sep 7, 2012 · N635CP · Substantial damageNTSB CEN12LA615Accident · 1 fatalLimited investigationFinal reportGoodyear F2G · Valley City, NDThe pilot’s decision to initiate the aerobatic maneuver at an altitude that did not allow for full recovery of the airplane before ground impact.Sep 7, 2012 · N5577N · Substantial damageNTSB ERA12LA549Accident · Serious injuriesLimited investigationFinal reportBeech 76 · Manville, NJThe pilot’s failure to maintain directional control during the landing and attempted go-around.Sep 6, 2012 · N6716L · Substantial damageNTSB ERA12CA551Accident · Minor injuriesData collectionFinal reportHolloman L B/Holloman E M Sonex · Chapmansboro, TNThe pilot’s failure to maintain directional control during the takeoff initial climb.Sep 6, 2012 · N484PC · Substantial damageNTSB CEN12FA611Accident · 1 fatalField investigationFinal reportFairley Gooch Lancair IV · Winnsboro, LAThe pilot’s failure to maintain control of the airplane after a loss of engine power during a go-around. Contributing to the accident was the difficult-to-operate fuel selector valve and the pilot’s continued operation of the airplane with a known mechanical…Sep 6, 2012 · N1126V · Substantial damageNTSB CEN12CA612Accident · No injuriesData collectionFinal reportHawker Beechcraft G36 · Decatur, TXThe pilot's delay in executing the aborted landing, which resulted in a runway excursion.Sep 6, 2012 · N563AP · Substantial damageNTSB WPR12LA413Accident · Serious injuriesLimited investigationFinal reportEllefson T-BIRD II · Richfield, UTA loss of control during landing due to a pitch control malfunction. Contributing to the accident was the pilot’s decision to continue flight with a known mechanical problem.Sep 5, 2012 · N8106C · Substantial damageNTSB ERA12CA547Accident · Minor injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P92 Tail Dragger · Elizabethtown, KYThe pilot’s failure to maintain directional control of the tailwheel-equipped airplane during a takeoff in gusty crosswind conditions. Contributing to the accident was the pilot's decision to take off in gusty wind conditions associated with approaching…Sep 5, 2012 · N237TA · Substantial damageNTSB DCA12IA141Incident · No injuriesIncident investigationFinal reportDe Havilland DHC8 · Soldotna, AKan in-flight loss of control due to the flight crew's inattention to airspeed, pitch attitude, and engine power during the climb leading to an aerodynamic stall. Contributing to the incident was the flight crew's failure to recognize and properly recover from…Sep 5, 2012 · N886EA · No damageNTSB CEN12FA606Accident · Serious injuriesField investigationFinal reportCessna 421B · Fort Worth, TXThe pilot's failure to maintain airplane control on takeoff, which resulted in an inadvertent stall. Contributing to the accident were the unlatched nose cargo door, the pilot’s diverted attention, and the pilot's mental ability to handle the emergency…Sep 5, 2012 · N69924 · Substantial damageNTSB ANC12CA101Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Ekwok, AKThe pilot's diverted attention during the initial climb, which resulted in a collision with trees.Sep 5, 2012 · N4127Z · Substantial damageNTSB WPR12CA401Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Lewiston, IDThe pilot’s inadequate postmaintenance and preflight inspections, which resulted in the separation of the left main wheel after takeoff. Contributing to the accident was the improperly secured left main wheel spindle nut.Sep 4, 2012 · N4798Z · Substantial damageNTSB WPR12CA400Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Lancaster, CAThe student pilot’s inadvertent selection of an empty fuel tank.Sep 4, 2012 · N308DF · Substantial damageNTSB WPR12CA393Accident · No injuriesData collectionFinal reportBeech 95-55 · Spanoway, WAThe pilot’s failure to lower the landing gear prior to landing.Sep 4, 2012 · N4QC · Substantial damageNTSB CEN12CA627Accident · No injuriesData collectionFinal reportSchneider John W PT-2A · Watkins, COThe pilot's loss of control during takeoff resulting in a runway excursion. Contributing to the accident was an unexpected wind gust.Sep 4, 2012 · N6744J · Substantial damageNTSB WPR12LA391Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Toledo, ORThe pilot’s failure to maintain directional control of the airplane after landing.Sep 3, 2012 · N3700V · Substantial damageNTSB WPR12FA395Accident · 1 fatalField investigationFinal reportSkykits USA Savannah ADV · Murtaugh, IDThe pilot's failure to maintain adequate airspeed while maneuvering at or above the airplane's maximum ceiling, which resulted in a stall and a subsequent loss of airplane control. Contributing to the accident was the pilot's decision to operate the airplane…Sep 3, 2012 · N9764J · Substantial damageNTSB WPR12CA397Accident · No injuriesData collectionFinal reportChampion 7GC · Spanish Fork, UTThe pilot’s failure to maintain directional control during the landing roll.Sep 3, 2012 · N61819 · Substantial damageNTSB WPR12CA390Accident · No injuriesData collectionFinal reportMaule MXT-7-180A · Manzanita, ORThe pilot’s inadequate compensation for the crosswind during landing, which resulted in a loss of directional control.Sep 3, 2012 · N353LS · Substantial damageNTSB ERA12LA543Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Tillatoba, MSThe pilot's improper fuel management and his decision to continue flight in deteriorating weather conditions with low fuel, which resulted in a total loss of engine power due to fuel exhaustion.Sep 3, 2012 · N761YN · Substantial damageNTSB ERA12CA560Accident · No injuriesData collectionFinal reportCessna 172S · Sebring, FLThe student pilot's improper flare, which resulted in a hard landing.Sep 3, 2012 · N9965P · Substantial damageNTSB CEN12CA608Accident · No injuriesData collectionFinal reportRolladen-Schneider OHG LS3-A · Navasota, TXThe pilot’s inadequate compensation for landing area conditions during an off-airport landing, which resulted in a loss of directional control and a collision with terrain.Sep 3, 2012 · N27UP · Substantial damageNTSB ANC12LA096Accident · Serious injuriesLimited investigationFinal reportTaylorcraft F21 · Willow, AKThe pilot’s failure to maintain control of the airplane after a loss of engine power during takeoff due to carburetor ice.Sep 3, 2012 · N2005E · Substantial damageNTSB WPR12CA389Accident · Minor injuriesData collectionFinal reportCessna 182L · Metaline Falls, WAThe pilot’s inadequate compensation for a sudden wind shift during the landing roll, which resulted in a runway overrun.Sep 2, 2012 · N42014 · Substantial damageNTSB WPR12CA388Accident · Minor injuriesData collectionFinal reportPiggott John H Bearhawk · Sequim, WAThe student pilot's failure to maintain directional control on landing.Sep 2, 2012 · N347JP · Substantial damageNTSB CEN12TA604Accident · Serious injuriesFinal reportCessna 182P · Newberry, MIThe pilot’s failure to maintain control of the airplane due to distraction from a combination of smoke in the cockpit and a sudden turbulence encounter while on short final approach. The cause of the cockpit smoke could not be determined due to the extensive…Sep 2, 2012 · N5981J · Substantial damageNTSB ANC12LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Coldfoot, AKThe pilot's failure to maintain clearance from terrain while maneuvering to reverse course.Sep 2, 2012 · N82016 · Substantial damageNTSB ANC12CA099Accident · No injuriesData collectionFinal reportCessna 180 · Kenai, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over.Sep 2, 2012 · N67178 · Substantial damageNTSB WPR12CA387Accident · No injuriesData collectionFinal reportCroman SH-3H · Covelo, CAThe pilot’s failure to maintain clearance from a tree during an aerial firefighting flight.Sep 1, 2012 · N611CK · Substantial damage