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 CEN11FA150Accident · 2 fatalField investigationFinal reportPiper PA 46-350P · Westcliffe, COThe pilot's loss of control following an encounter with moderate to severe weather.Jan 9, 2011 · N727MC · Substantial damageNTSB WPR11FA090Accident · 2 fatalField investigationFinal reportBeech S35 · Chester, CAThe pilot's loss of control while maneuvering to land, most likely due to spatial disorientation.Jan 7, 2011 · N5866S · Substantial damageNTSB WPR11CA091Accident · No injuriesData collectionFinal reportMaule M-4-180V · Elko, NVThe pilot's failure to maintain directional control of the airplane during landing.Jan 7, 2011 · N799ZZ · Substantial damageNTSB ERA11FA107Accident · 1 fatalField investigationFinal reportBeech 58P · Birmingham, ALThe pilot's failure to maintain control of the airplane during an instrument approach due to spatial disorientation.Jan 6, 2011 · N48TS · Substantial damageNTSB ERA11CA109Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Lancaster, SCThe pilot's failure to maintain directional control during an attempted go-around maneuver after landing.Jan 6, 2011 · N929TC · Substantial damageNTSB ERA11CA108Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Thomaston, GAThe mechanic's failure to install a cotter retaining pin in the throttle arm retaining nut resulting in excessive throttle play and loss of engine power control.Jan 6, 2011 · N5706D · Substantial damageNTSB CEN11FA144Accident · Minor injuriesField investigationFinal reportGates Learjet 35A · Springfield, ILThe pilot’s decision to conduct an instrument approach in icing conditions without the anti-ice system activated, contrary to the airplane flight manual guidance, which resulted in an inadvertent aerodynamic stall due to an in-flight accumulation of airframe…Jan 6, 2011 · N800GP · Substantial damageNTSB ANC11LA009Accident · No injuriesLimited investigationFinal reportCessna 208B · Kipnuk, AKThe pilot’s decision to land long on the icy snow-covered runway, resulting in a runway excursion and collision with terrain.Jan 6, 2011 · N715HE · Substantial damageNTSB CEN11CA147Accident · Minor injuriesData collectionFinal reportPegasus 503 Sport · Cambridge, OHThe pilot's failure to maintain clearance from trees and terrain during the landing approach.Jan 5, 2011 · N456KL · Substantial damageNTSB WPR11CA088Accident · No injuriesData collectionFinal reportFerkin Kitfox IV · Homedale, IDThe pilot's inadequate compensation for the snow-covered terrain during the takeoff ground roll, which resulted in a nose-over.Jan 4, 2011 · N90TY · Substantial damageNTSB WPR11CA085Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Wickenburg, AZThe student pilot's failure to maintain clearance between the airplane's right wing and the pole.Jan 4, 2011 · N443PA · Substantial damageNTSB CEN11LA138Accident · 1 fatalLimited investigationFinal reportCessna 172H · Walnut Grove, MOThe pilot's loss of control for undetermined reasons. Contributing to the accident was the pilot's fatigue.Jan 4, 2011 · N1416F · Substantial damageNTSB ANC11LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Platinum, AKThe pilot's misidentification of the airport's active runway, resulting in an off-runway landing and collision with a ditch/berm.Jan 4, 2011 · N9304K · Substantial damageNTSB ERA11LA104Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Benton, PAThe pilot's failure to maintain clearance from terrain during the night flight.Jan 3, 2011 · N42997 · Substantial damageNTSB DCA11FA050Accident · No injuriesField investigationFinal reportBoeing 737-823 · Los Angeles, CAthe early rotation of the airplane to an angle at which the fuselage contacted the runway. Contributing to early rotation was the Captain’s reaction to the erroneous V1 automated callout, likely assuming that the airplane was at or close to the correct Vr at…Jan 3, 2011 · N831NN · Substantial damageNTSB ANC11LA007Accident · No injuriesLimited investigationFinal reportBeech E18S-9700 · New Stuyahok, AKThe pilot's misjudgment of the runway surface condition, resulting in an aborted landing and collision with rising terrain during the ensuing takeoff attempt.Jan 3, 2011 · N9001 · Substantial damageNTSB CEN11LA142Accident · No injuriesLimited investigationFinal reportAmerican Legend AL3 · McKinney, TXThe pilot's loss of directional control during landing.Jan 2, 2011 · N102PJ · Substantial damageNTSB CEN11CA152Accident · No injuriesData collectionFinal reportEurocopter Deutschland MBB-BK 117 C-2 · Albert Lea, MNThe pilot's inadequate preflight inspection of the engine cowling latches prior the flight, which resulted in the cowling door opening in-flight and striking the main rotor blades.Jan 2, 2011 · N145SM · Substantial damageNTSB CEN11CA137Accident · No injuriesData collectionFinal reportBellanca 1419 · Clovis, NMThe pilot's failure to maintain directional control of the airplane during landing.Jan 2, 2011 · N8516R · Substantial damageNTSB WPR11CA086Accident · No injuriesData collectionFinal reportGiorgio Anthony J RV4 · Torrance, CAThe pilot's inadequate landing flare that resulted in a hard landing and a ground loop.Jan 1, 2011 · N322RV · Substantial damageNTSB ERA11FA102Accident · 1 fatalField investigationFinal reportCessna 310F · Orange, MAThe pilot did not maintain separation from trees during landing. Contributing to the accident was the pilot’s inadequate preflight planning and lack of recent night flight experience.Jan 1, 2011 · N6725X · Substantial damageNTSB WPR11TA083Accident · No injuriesFinal reportQuest Kodiak 100 · Reedsport, ORThe pilot's failure to maintain clearance from power lines during a low-level aerial observation flight. Contributing to the accident was pilot's failure to review a route hazards map prior to initiating the flight.Dec 31, 2010 · N702FW · Substantial damageNTSB WPR11CA097Accident · No injuriesData collectionFinal reportCessna 180 · Flagstaff, AZThe pilot's failure to maintain directional control during landing that resulted in a ground loop.Dec 31, 2010 · N67F · Substantial damageNTSB OPS11IA273Incident · No injuriesIncident investigationFinal reportEmbraer ERJ190 · Denver, COThe driver of the operation vehicle's misidentification of the runway for an adjacent taxiway, resulting in a runway incursion with an aircraft in position for takeoff.Dec 31, 2010 · C-FHKA · No damageNTSB ERA11LA105Accident · No injuriesLimited investigationFinal reportCessna 172 · Dublin, NCThe pilot’s improper touchdown speed which resulted in a runway overrun. Contributing to the accident was the undetermined malfunction of the airspeed indicator.Dec 31, 2010 · N4383Q · Substantial damageNTSB ERA11LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · Wimauma, FLThe mechanic/pilot's failure to detect a visible exhaust gas leak and cracked cylinder head immediately prior to the accident flight, which resulted in a partial loss of engine power during initial climb. Contributing to the accident was an inadequate…Dec 31, 2010 · N28BA · Substantial damageNTSB ERA11FA101Accident · 2 fatalField investigationFinal reportCessna 172H · Weyers Cave, VAThe inherent limitations of the see-and-avoid concept, which made it difficult for the helicopter pilot to see the airplane before the collision. Contributing to the accident was the airplane pilot’s non-standard entry to the airport traffic pattern, which,…Dec 31, 2010 · N2876L · 2 aircraft · Substantial damageNTSB CEN11FA133Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Milaca, MNThe pilot did not recover from an unusual attitude while operating in instrument meteorological conditions following a disconnect of the autopilot system for undetermined reasons. Contributing to the accident were the pilot’s lack of recent flight experience…Dec 30, 2010 · N9103N · Substantial damageNTSB ERA11LA106Accident · No injuriesLimited investigationFinal reportEurocopter MBB-BK · Cherry Point, NCThe pilot's impairment during cruise flight due to a recurring stroke. Contributing to the accident was the Federal Aviation Administration's inadequate oversight of the pilot's known medical condition.Dec 29, 2010 · N854EC · Substantial damageNTSB DCA11IA015Incident · No injuriesClass 1 · IncidentFinal reportBoeing 757-223 · Jackson Hole, WYa manufacturing defect in a clutch mechanism that prevented the speedbrakes from automatically deploying after touchdown, and the captain’s failure to monitor and extend the speedbrakes manually. Also causal was the failure of the thrust reversers to deploy…Dec 29, 2010 · N668AA · No damageNTSB CEN11CA132Accident · No injuriesData collectionFinal reportCessna T210L · Abilene, TXThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Dec 29, 2010 · N210BH · Substantial damageNTSB CEN11CA136Accident · Minor injuriesData collectionFinal reportAero Commander 500-B · Columbus, OHThe pilot’s improper fuel management which resulted in a loss of engine power due to fuel exhaustion.Dec 28, 2010 · N888CA · Substantial damageNTSB ERA11CA170Accident · No injuriesData collectionFinal reportCessna 195 · Williamson, GAThe pilot's inadvertent application of the brakes during a bounced landing resulting in a nose over.Dec 27, 2010 · N3464V · Substantial damageNTSB CEN11FA130Accident · 1 fatalField investigationFinal reportCessna 210B · Loveland, COThe pilot's intentional flight into terrain.Dec 27, 2010 · N200EP · Substantial damageNTSB ENG11IA011Incident · No injuriesIncident investigationFinal reportBoeing 737 · San Francisco, CAThe probable cause of the undercowl in-flight engine fire was the insufficient installation torque of the bolts that secure the fuel manifold cover to the fuel manifold. Engine vibrations and fuel pressure cycles caused the bolts to gradually loosen further…Dec 25, 2010 · N248WN · No damageNTSB CEN11CA139Accident · No injuriesData collectionFinal reportCessna 305A · Spooner, WIThe pilot's selection of unsuitable terrain for landing on a snow-covered lake.Dec 25, 2010 · N6897 · Substantial damageNTSB ERA11LA099Accident · No injuriesLimited investigationFinal reportBeech F35 · Syracuse, NYThe pilot’s failure to maintain adequate airspeed during landing with airframe structural icing, resulting in an aerodynamic stall and subsequent hard landing. Contributing to the accident was the pilot’s continued flight into known icing conditions.Dec 24, 2010 · N3448B · Substantial damageNTSB ERA11CA097Accident · No injuriesData collectionFinal reportCessna 140 · Winnsboro, SCThe excessive brake inputs by both pilots during the landing roll resulting in the airplane nosing over.Dec 24, 2010 · N76831 · Substantial damageNTSB WPR11LA080Accident · Serious injuriesLimited investigationFinal reportSchaefer Kitfox 4 · Glendale, AZThe pilot's failure to recognize the onset of and to prevent an aerodynamic stall at low altitude. Contributing to the accident were the manufacturer’s conflicting guidance about the power setting for takeoff and the pilot’s decision to conduct a…Dec 23, 2010 · N95FT · Substantial damageNTSB ERA11FA095Accident · 1 fatalField investigationFinal reportMooney M20R · Dundee, NYThe pilot's decision to operate in known moderate-to-severe icing conditions, which resulted in a loss of control during approach.Dec 23, 2010 · N968SM · Substantial damageNTSB ERA11CA096Accident · No injuriesData collectionFinal reportCessna 172S · Fort Myers, FLThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the pilot’s attempt to take off with full flaps.Dec 23, 2010 · N385ME · Substantial damageNTSB ANC11CA005Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Clear, AKThe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to water/ice in the fuel system.Dec 23, 2010 · N40283 · Substantial damageNTSB WPR11LA081Accident · No injuriesLimited investigationFinal reportApollo AS-III · Poipu, HIThe pilot's lack of compliance with manufacturer's guidance for care and handling of the aircraft combined with incomplete preflight inspections, which resulted in an undetected material failure of the nose cone.Dec 22, 2010 · N157AP · Substantial damageNTSB WPR11FA082Accident · 3 fatalField investigationFinal reportAero Commander 114B · Lander, WYThe non-instrument-rated pilot's decision to continue visual flight in instrument or marginal visual meteorological conditions in mountainous terrain, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's lack of…Dec 22, 2010 · N799RS · Substantial damageNTSB WPR11CA079Accident · No injuriesData collectionFinal reportMoyes Bailey Microlite · Newberg, ORThe pilot's improper recovery from a dive, which resulted in a loss of control.Dec 22, 2010 · N7008Z · Substantial damageNTSB CEN11FA125Accident · 1 fatalField investigationFinal reportBeech C24R · Wheeling, ILThe installation of the wrong engine-driven fuel pump, which resulted in a loss of engine power during takeoff, and the pilot's subsequent decision to turn back toward the airport at an insufficient altitude to complete the maneuver. Contributing to the…Dec 22, 2010 · N5293M · Substantial damageNTSB CEN11FA124Accident · 2 fatalField investigationFinal reportMooney M20E · Colorado Springs, COThe pilot’s decision to initiate an approach into weather conditions where the ceiling and visibility were below the minimums for the approach and where reported icing existed, in an airplane not certified for flight in icing conditions, and his failure to…Dec 22, 2010 · N79869 · Substantial damageNTSB CEN11CA126Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Hemphill, TXThe student pilot’s improper decision to carry an unauthorized passenger and the passenger’s loss of control of the helicopter during take-off.Dec 22, 2010 · N841SA · Substantial damageNTSB CEN11CA128Accident · No injuriesData collectionFinal reportCessna 340A · Madison, WIThe pilot's failure to maintain adequate airspeed during the approach, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's failure to check the de-ice fluid level prior to takeoff, which resulted in the failure of the de-ice…Dec 21, 2010 · N233DS · Substantial damageNTSB CEN11CA127Accident · No injuriesData collectionFinal reportCessna 182P · Clifton, TXThe pilot's inadequate compensation for the crosswind and inadequate flare, which resulted in a hard landing.Dec 21, 2010 · N9317G · Substantial damage