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 WPR13CA097Accident · No injuriesData collectionFinal reportCessna 140 · Tucson, AZThe pilot’s failure to maintain directional control during the landing roll and his excessive application of brakes, which resulted in a noseover.Jan 21, 2013 · N223PE · Substantial damageNTSB WPR13LA098Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Marysville, CAA total loss of engine power during initial climb due to fuel starvation, which resulted from maintenance personnel’s improper installation of the fuel selector handle. Contributing to the accident was an incorrectly modified fuel selector handle assembly.Jan 20, 2013 · N5208F · Substantial damageNTSB WPR13LA096Accident · Serious injuriesLimited investigationFinal reportQuicksilver Sport IIS · Camarillo, CAThe person on the ground’s failure to stay clear of a spinning propeller.Jan 20, 2013 · N1712 · No damageNTSB CEN13CA138Accident · Minor injuriesData collectionFinal reportCessna 170B · Erie, COThe pilot’s failure to maintain control of the airplane while taking off in gusting wind conditions.Jan 20, 2013 · N2323D · Substantial damageNTSB WPR13FA095Accident · 2 fatalField investigationFinal reportCessna 140 · Boulder, UTThe pilot’s improper decision to maneuver at a low altitude and failure to adequately monitor the environment to maintain clearance from power lines.Jan 19, 2013 · N2341N · Substantial damageNTSB CEN13FA137Accident · 3 fatalField investigationFinal reportBeech 95-B55 (T42A) · Mangum, OKThe airplane's aerodynamic stall/spin at low altitude and subsequent impact with terrain for reasons that could not be determined during postaccident examinations. Contributing to the accident was the pilot's lack of currency/proficiency.Jan 19, 2013 · N143E · Substantial damageNTSB WPR13LA102Accident · No injuriesLimited investigationFinal reportCessna 172RG · Redmond, ORFailure of the left main landing gear pivot assembly during the landing approach.Jan 18, 2013 · N6290V · Substantial damageNTSB WPR13LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Rock Springs, WYThe pilot's inadvertent movement of the fuel selector valve beyond its tank detent, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the failure of the fuel selector interlock mechanism.Jan 18, 2013 · N49DS · Substantial damageNTSB WPR13CA103Accident · No injuriesData collectionFinal reportCessna 150J · Porterville, CAThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Jan 18, 2013 · N50690 · Substantial damageNTSB ERA13LA116Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Ellington, CTThe separation of the collective push-pull tube and jackshaft assembly, which resulted in the total loss of helicopter control and collision with terrain. Contributing to the accident was the inadequate supervision of maintenance personnel by the operator…Jan 17, 2013 · N26NE · Substantial damageNTSB DCA13LA039Accident · No injuriesLimited investigationFinal reportBoeing 777 - 300 · Miami, FLLV-BMT flight crew's incorrect evaluation of the clearance between the two aircraft, leading to the inadvertent collision of the left winglet with the horizontal stabilizer and elevator of F-GNZI. Contributing to the accident were the incorrect instructions…Jan 17, 2013 · F-GZNI · 2 aircraft · Substantial damageNTSB CEN13CA139Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Phillipsburg, OHThe pilot's improper operation of the airplane controls during engine start, which resulted in a collision with a hangar.Jan 17, 2013 · N5269P · Substantial damageNTSB ERA13FA115Accident · 1 fatalField investigationFinal reportPilatus PC-12/45 · Burlington, NCThe pilot's failure to maintain airplane control due to spatial disorientation during the initial climb after takeoff in night instrument flight rules conditions.Jan 16, 2013 · N68PK · Substantial damageNTSB CEN13FA135Accident · 1 fatalField investigationFinal reportCessna 208B · Pellston, MIThe pilot's inadvertent controlled descent into terrain due to spatial disorientation. Contributing to the accident was lack of visual reference due to night conditions.Jan 16, 2013 · N1120N · DestroyedNTSB WPR13CA104Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Torrance, CAThe pilot’s improper landing flare, which resulted in a bounced landing.Jan 15, 2013 · N5384W · Substantial damageNTSB CEN13CA136Accident · No injuriesData collectionFinal reportAviat A-1C-180 · Upper Sandusky, OHThe pilot's failure to maintain directional control while landing in gusty crosswind conditions.Jan 15, 2013 · N7ZR · Substantial damageNTSB ERA13LA113Accident · 1 fatalLimited investigationFinal reportPiper PA-34-200T · Manteo, NCThe pilot's attempted visual flight in instrument meteorological conditions while maneuvering at a low altitude in the traffic pattern, which resulted in spatial disorientation and impact with the water. Contributing was the pilot's lack of experience flying…Jan 13, 2013 · N6537C · DestroyedNTSB ERA13LA111Accident · 1 fatalLimited investigationFinal reportPiper PA-28R-200 · Dover, DEThe pilot's failure to land the airplane at multiple airports that were equipped with adequate instrument approach procedures while operating in low instrument meteorological conditions and his delay in declaring a fuel-related emergency, which resulted in a…Jan 13, 2013 · N4975S · Substantial damageNTSB ERA13IA114Incident · No injuriesIncident investigationFinal reportCessna 560XL · Debary, FLAn accumulation of debris in the airplane’s bilge drain holes that prevented accumulated moisture from properly draining; the accumulated moisture subsequently froze around the elevator control components, which resulted in the flight control stiffness.…Jan 13, 2013 · N662QS · No damageNTSB ERA13LA110Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Winder, GAA total loss of engine power due to a cracked fuel pump line fitting O-ring seal at the inlet to the engine driven fuel pump. Contributing to the accident was the failure of the aircraft operator to comply with the engine manufacturer’s recommended time…Jan 12, 2013 · N3898T · Substantial damageNTSB CEN13FA131Accident · 3 fatalField investigationFinal reportPiper PA46-500TP · Paris, TXThe pilot's encounter with convective weather, which resulted in a loss of airplane control.Jan 12, 2013 · N5339V · DestroyedNTSB CEN13CA133Accident · No injuriesData collectionFinal reportAmerican General Acft AG5B · Ankeny, IAThe pilot’s failure to maintain a proper glide path to the runway in gusty wind conditions and his failure to maintain clearance from obstructions during the subsequent go-around. Contributing to the accident was the pilot's improper interior lighting…Jan 12, 2013 · N897GA · Substantial damageNTSB CEN13FA130Accident · 4 fatalField investigationFinal reportRaytheon 58 · Maxwell, NEThe pilot’s inadvertent encounter with severe icing conditions, which resulted in structural icing and the subsequent loss of airplane control.Jan 11, 2013 · N36VE · DestroyedNTSB CEN13CA129Accident · No injuriesData collectionFinal reportBeech 65-B80 · Alexandria, MNThe pilot’s failure to stop the airplane on the downsloping, ice-contaminated runway after landing with a tailwind. Contributing to the accident was the pilot’s failure to account for the wind conditions and failure to obtain runway conditions.Jan 11, 2013 · N110BA · Substantial damageNTSB CEN13CA134Accident · No injuriesData collectionFinal reportMooney M20C · Moriarty, NMThe pilot’s improper fuel management, which resulted in a loss of engine power during cruise flight due to fuel starvation.Jan 10, 2013 · N6242U · Substantial damageNTSB WPR13CA089Accident · Minor injuriesData collectionFinal reportStribling James L RV4 · Georgetown, CAThe pilot’s improper landing flare and failure to maintain directional control during landing.Jan 8, 2013 · N70AC · Substantial damageNTSB WPR13CA088Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Rialto, CAThe pilot's failure to maintain airplane control while taxiing in gusting wind conditions.Jan 8, 2013 · N1254E · Substantial damageNTSB WPR13FA086Accident · 2 fatalField investigationFinal reportBeech V35A · Woody, CAAn in-flight encounter with icing conditions during descent, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall followed by an in-flight breakup.Jan 7, 2013 · N35SD · DestroyedNTSB ERA13CA107Accident · No injuriesData collectionFinal reportBrewer James M KR2 · Bear Branch, KYThe pilot’s improper preflight planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the fuel exhaustion was the pilot’s lack of knowledge about the airplane’s total fuel capacity and fuel quantity instrumentation.Jan 7, 2013 · N216CB · Substantial damageNTSB CEN13LA132Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Antlers, OKThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Jan 7, 2013 · N222EG · Substantial damageNTSB WPR13LA085Accident · Minor injuriesLimited investigationFinal reportJeremiah Jackson Vans RV-10 · Julian, CAA loss of engine power due to oil starvation as a result of a disconnected oil line. Contributing to the accident was an insufficiently tightened oil line fitting.Jan 5, 2013 · N262NJ · Substantial damageNTSB ANC13CA020Accident · No injuriesData collectionFinal reportCessna A185E · Skwentna, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a main landing gear collapse.Jan 5, 2013 · N4538F · Substantial damageNTSB ERA13FA105Accident · 3 fatalField investigationFinal reportBeech H35 · Palm Coast, FLA total loss of engine power after the failure of the No. 4 connecting rod due to oil starvation, which resulted in a subsequent forced landing. Contributing to the accident was the pilot’s failure to clearly state that the aircraft had lost all power and the…Jan 4, 2013 · N375B · DestroyedNTSB ANC13CA019Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Palmer, AKThe pilot's selection of unsuitable terrain for an off-airport landing, which resulted in a ground-loop.Jan 4, 2013 · N7780Y · Substantial damageNTSB WPR13FA083Accident · 1 fatalField investigationFinal reportLuscombe 8A · Oceano, CAThe pilot’s failure to maintain airplane control and his improper decision to begin a low-level maneuver at an altitude that was not sufficient for recovery before ground impact. Contributing to the accident was the pilot’s impairment from marijuana use.Jan 3, 2013 · N45923 · Substantial damageNTSB WPR13CA084Accident · Minor injuriesData collectionFinal reportBell 47G · Five Points, CAThe pilot’s failure to maintain clearance with a telephone pole during a low-level maneuver.Jan 3, 2013 · N14841 · Substantial damageNTSB CEN13FA122Accident · 3 fatalField investigationFinal reportBell Helicopter 407 · Clear Lake, IAThe pilot’s inadvertent encounter with localized icing conditions and his subsequent in-flight loss of helicopter control.Jan 3, 2013 · N445MT · DestroyedNTSB WPR13LA082Accident · No injuriesLimited investigationFinal reportPiper PA-60-602P · North Las Vegas, NVThe pilot’s failure to maintain an adequate descent rate while on final approach, which resulted in a hard landing and landing gear collapse due to overload following the failure of both engines to respond to power inputs during an attempted go-around for…Jan 2, 2013 · N3AG · Substantial damageNTSB WPR13FA080Accident · 1 fatalField investigationFinal reportBell 206 · Delano, CAThe pilot's failure to maintain helicopter control due to spatial disorientation while maneuvering in low visibility, dark night conditions.Jan 2, 2013 · N828AC · DestroyedNTSB ERA13LA104Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Tampa, FLThe student pilot’s delayed throttle application during the practice autorotation and the flight instructor’s lack of immediate remedial action, which resulted in a hard landing.Jan 2, 2013 · N345VH · Substantial damageNTSB ERA13FA101Accident · 3 fatalField investigationFinal reportPiper PA-30 · Jasper, ALThe student pilot’s poor judgment to take a multiengine airplane for which he did not have experience or permission to operate and depart into night instrument meteorological conditions, which resulted in a loss of airplane control and impact with terrain.Jan 2, 2013 · N7700Y · DestroyedNTSB CEN13LA127Accident · No injuriesLimited investigationFinal reportLuscombe 8 · Elkhart, INThe pilot’s improper flare, which resulted in a bounced landing.Jan 2, 2013 · N707HL · Substantial damageNTSB CEN13FA121Accident · Serious injuriesField investigationFinal reportEurocopter EC130 B4 · Seminole, OKThe loss of engine power due to ice ingestion. Contributing to the accident was maintenance personnel’s delayed decision to install the helicopter's engine inlet cover until after the engine had been exposed to moisture and freezing temperatures and their…Jan 2, 2013 · N334AM · Substantial damageNTSB CEN13CA124Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Menard, TXThe helicopter landed hard during a forced landing.Jan 2, 2013 · N744RM · Substantial damageNTSB WPR13CA079Accident · No injuriesData collectionFinal reportCessna 182P · Chiloquin, ORThe flight instructor’s failure to maintain airplane control during a landing on a snow-covered runway.Jan 1, 2013 · N58677 · Substantial damageNTSB WPR13LA093Accident · No injuriesLimited investigationFinal reportKaufmann Vans RV-10 · Las Vegas, NVA missing elevator control assembly attachment bolt, which rendered the elevator control system ineffective and resulted in a loss of pitch control, and the pilot’s incorrect installation of the elevator control assembly.Dec 31, 2012 · N104BK · Substantial damageNTSB ERA13CA100Accident · No injuriesData collectionFinal reportRaytheon A36 · Rutland, VTThe pilot's failure to maintain control of the airplane while maneuvering on a snow-packed surface after landing, which resulted in a collision with a fuel truck.Dec 31, 2012 · N256DB · Substantial damageNTSB CEN13CA120Accident · No injuriesData collectionFinal reportRobidoux Lionel Wittman W 10 · Hobart, INThe pilot’s failure to maintain adequate airspeed during landing, which resulted in an aerodynamic stall and subsequent hard landing.Dec 30, 2012 · N641TD · Substantial damageNTSB WPR13FA076Accident · 3 fatalField investigationFinal reportMckenzie Lancair IV-P Turbine · Lakeside, CAThe pilot’s failure to maintain airspeed while attempting a visual climb through a broken cloud layer, which resulted in a stall/spin.Dec 29, 2012 · N5M · Substantial damageNTSB WPR13TA081Accident · No injuriesFinal reportBell Helicopter Textron Canada 407 · Renton, WAThe pilot's failure to maintain helicopter control during takeoff from an unstable landing platform. Contributing to the accident was the operator's inadequate chocking procedures for the wheeled landing platform, which included chocking only two of the…Dec 28, 2012 · N407KS · Substantial damage