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 WPR12LA359Accident · Serious injuriesLimited investigationFinal reportFechtner KR-2 · Tehachapi, CAThe pilot's failure to maintain control of the airplane during the approach to the airport.Aug 14, 2012 · N37686 · Substantial damageNTSB WPR12CA358Accident · Serious injuriesData collectionFinal reportBoughner R 80 Tiger Moth · Ramona, CAThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel starvation.Aug 14, 2012 · N615SX · Substantial damageNTSB WPR12CA357Accident · No injuriesData collectionFinal reportCessna 172R · Everett, WAThe pilot’s failure to maintain directional control during takeoff.Aug 14, 2012 · N863CP · Substantial damageNTSB CEN12CA590Accident · No injuriesData collectionFinal reportCessna 180J · Wausau, WIThe pilot's loss of control during landing roll out, resulting in a runway excursion. Contributing to the accident was an unexpected crosswind wind gust.Aug 14, 2012 · N52187 · Substantial damageNTSB CEN12CA546Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · Hanley Falls, MNThe pilot’s failure to maintain clearance from a guy wire during an agricultural application pass.Aug 14, 2012 · N1021D · Substantial damageNTSB CEN12LA545Accident · Serious injuriesLimited investigationFinal reportDykas Kitfox Series 7 · Monroe, MIThe inadequate descent angle flown by the pilot during a final approach for landing, which resulted in an in-flight collision with a power line.Aug 13, 2012 · N646FD · Substantial damageNTSB ANC12CA086Accident · No injuriesData collectionFinal reportPiper PA-18 · Anchorage, AKThe passenger's inadvertent application of the brake pedals during landing, which resulted in a noseover.Aug 13, 2012 · N37WP · Substantial damageNTSB WPR12CA354Accident · No injuriesData collectionFinal reportPiper PA-22 · Napa, CAThe pilot's inadequate landing flare, which resulted in a bounced landing and subsequent loss of directional control during the landing roll.Aug 12, 2012 · N3580A · Substantial damageNTSB WPR12CA352Accident · No injuriesData collectionFinal reportCessna 180 · Upland, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll in gusting wind conditions.Aug 12, 2012 · N2927K · Substantial damageNTSB ERA12LA509Accident · Serious injuriesLimited investigationFinal reportDestiny XLT 2000 · Grayson, GAThe non-certificated pilot’s inadequate preflight inspection, which resulted in a loss of engine power due to fuel exhaustion.Aug 12, 2012 · N103ME · Substantial damageNTSB ERA12CA506Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Myerstown, PAThe student pilot's decision to continue the takeoff roll while trying to secure an open canopy and his subsequent failure to maintain directional control. Contributing to the accident was the student pilot's failure to complete the pretakeoff checklist.Aug 12, 2012 · N633EV · Substantial damageNTSB CEN12LA626Accident · No injuriesLimited investigationFinal reportIson Eros · Schoolcraft, MIThe operation of an airplane by a non-certificated pilot and his failure to maintain airplane control during the initial climb, which resulted in an uncontrolled decent.Aug 12, 2012 · N4007B · Substantial damageNTSB WPR12FA349Accident · 1 fatalField investigationFinal reportCessna P210N · Santa Monica, CAThe pilot's failure to maintain altitude during a return to the airport following an unspecified emergency; the nature of the emergency could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would…Aug 11, 2012 · N41KA · Substantial damageNTSB WPR12CA351Accident · Minor injuriesData collectionFinal reportRobinson R22 · Monticello, UTThe pilot's failure to maintain adequate main rotor rpm while maneuvering at a low altitude, which resulted in the helicopter settling and subsequently colliding with the ground. Contributing to the accident was that the pilot had insufficient altitude to…Aug 11, 2012 · N7135J · Substantial damageNTSB ERA12LA500Accident · No injuriesLimited investigationFinal reportBeech V35B · Effingham, SCThe pilot's failure to avoid an encounter with known adverse weather conditions, which resulted in an in-flight upset, temporary loss of control, and loading of the airframe, engine, and propeller that led to the in-flight separation of the propeller and the…Aug 11, 2012 · N11JK · Substantial damageNTSB CEN12LA541Accident · No injuriesLimited investigationFinal reportCessna 177RG · Litchfield, ILThe pilot's failure to maintain airplane control during the landing and the subsequent aborted landing.Aug 11, 2012 · N1564H · Substantial damageNTSB CEN12LA540Accident · Minor injuriesLimited investigationFinal reportJames H Berard RV-6A · Westfield, INThe pilot’s failure to maintain control of the airplane after takeoff.Aug 11, 2012 · N134CE · Substantial damageNTSB CEN12LA539Accident · Minor injuriesLimited investigationFinal reportGn-1 Aircamper Mathes · Burlington, WIThe pilot's improper installation of the propeller bolts, which resulted in the in-flight separation of the propeller.Aug 11, 2012 · N31TM · Substantial damageNTSB CEN12FA534Accident · 1 fatalField investigationFinal reportBeech G18 - S · Taylorville, ILThe pilot's failure to maintain adequate airspeed and use the appropriate flaps setting during sport-parachuting operations, which resulted in an aerodynamic stall/spin and a subsequent loss of control. Contributing to the accident was the pilot’s failure to…Aug 11, 2012 · N697Q · Substantial damageNTSB CEN12CA537Accident · No injuriesData collectionFinal reportGage Midget Mustang MM-1 · Erie, COThe pilot's inadequate compensation for the crosswind conditions during takeoff, which resulted in a loss of directional control.Aug 11, 2012 · N41831 · Substantial damageNTSB WPR12CA350Accident · No injuriesData collectionFinal reportCessna 152 · Eastvale, CAThe failure of both pilots to ensure that no water was present in the fuel, which resulted in a complete loss of engine power and a forced off-field landing.Aug 10, 2012 · N94185 · Substantial damageNTSB DCA12CA122Accident · No injuriesData collectionFinal reportAirbus A330 · Dulles, VAthe A330 flightcrew's failure to maintain a safe clearance between his wing and the tail of the DHC-8-400 that was stopped on the lead in line of the gate.Aug 10, 2012 · D-AIKE · 2 aircraft · Minor damageNTSB CEN12LA573Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Belgium, WIThe pilot’s failure to maintain control of the helicopter while landing in gusting wind conditions, which resulted in a hard landing.Aug 10, 2012 · N144DZ · Substantial damageNTSB CEN12CA548Accident · No injuriesData collectionFinal reportSchleicher ASW22 · Uvalde, TXThe pilot did not fully stow the glider’s airbrakes, which prevented the glider from obtaining adequate airspeed during the takeoff roll.Aug 10, 2012 · OK-2227 · Substantial damageNTSB ERA12CA502Accident · No injuriesData collectionFinal reportMaule M-4C · Lincoln, METhe pilot's failure to maintain directional control during the landing roll.Aug 9, 2012 · N9838M · Substantial damageNTSB CEN12CA542Accident · No injuriesData collectionFinal reportPiper PA-36-285 · Harvey, NDThe pilot’s decision to take off with the airplane over its maximum gross weight on a turf runway and with a tailwind, and his subsequent failure to maintain airplane control.Aug 8, 2012 · N204AB · Substantial damageNTSB ANC12FA084Accident · 1 fatalField investigationFinal reportMcdonnell Douglas Helicopter 600N · Delta Junction, AKThe pilot’s failure to clear the left landing gear skid, which resulted in the entanglement of the left landing gear skid with a log, and his subsequent application of collective pitch, which resulted in a dynamic rollover.Aug 8, 2012 · N737TV · Substantial damageNTSB ERA12CA499Accident · No injuriesData collectionFinal reportAeronca 7CCM · Norridgewock, METhe student pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion.Aug 7, 2012 · N83129 · Substantial damageNTSB CEN12LA538Accident · No injuriesLimited investigationFinal reportCantlon Starduster Too SA300 · Galion, OHThe pilot's failure to maintain directional control and a proper pitch attitude and airspeed while performing an aborted landing.Aug 7, 2012 · N111LC · Substantial damageNTSB CEN12LA530Accident · Serious injuriesLimited investigationFinal reportWilliams John T-51 Mustang · Oshkosh, WIThe separation of an engine cooling hose from the radiator.Aug 7, 2012 · N151TA · Substantial damageNTSB CEN12LA529Accident · No injuriesLimited investigationFinal reportPiper PA32RT · Palo Pinto, TXThe pilot's failure to maintain directional control and a proper pitch attitude and airspeed while performing a go-around.Aug 7, 2012 · N36103 · Substantial damageNTSB CEN12LA525Accident · No injuriesLimited investigationFinal reportBell 214ST · Avalon, TXMaintenance personnel’s failure to properly torque the retaining nut and install the cotter pin that secured the helicopter’s tail rotor counterweight bellcrank. Contributing to the accident was the lack of detailed maintenance records that documented…Aug 7, 2012 · N409SB · Substantial damageNTSB CEN12CA613Accident · No injuriesData collectionFinal reportBeech A36 · Washington, MOThe pilot raised the landing gear handle instead of the flap handle during a touch-and-go landing, resulting in the collapse of the nose landing gear while accelerating to takeoff.Aug 7, 2012 · N41HC · Substantial damageNTSB CEN12CA533Accident · No injuriesData collectionFinal reportThrush S-2R · Newkirk, OKThe pilot’s failure to maintain clearance from power lines.Aug 7, 2012 · N5596X · Substantial damageNTSB WPR12CA346Accident · No injuriesData collectionFinal reportCessna 208 · Chula Vista, CAThe pilot's failure to arrest the aircraft's sink rate on short final, which resulted in a hard landing.Aug 6, 2012 · N9727F · Substantial damageNTSB CEN12FA521Accident · No injuriesField investigationFinal reportAyres S2R-T34 · Lakin, KSThe pilot's failure to maintain clearance from the corn during an aerial application flight.Aug 6, 2012 · N365SM · Substantial damageNTSB WPR12CA344Accident · No injuriesData collectionFinal reportRotorway Exec · Colville, WAThe pilot's lack of experience in the helicopter, which resulted in his failure to maintain ground clearance during the taxi hover, followed by inadvertent ground contact and rollover.Aug 5, 2012 · N156RW · Substantial damageNTSB ERA12LA498Accident · Serious injuriesLimited investigationFinal reportEmbraer ERJ 170-200 LR · Hilton Head, SCThe passenger’s failure to adhere to flight and cabin crewmembers’ instructions to remain seated in anticipation of adverse weather and turbulence along the airplane’s flight path.Aug 5, 2012 · N134HQ · No damageNTSB CEN12IA518Incident · No injuriesIncident investigationFinal reportBell 407 · San Antonio, TXThe pilot’s failure to maintain clearance from a tower guy wire during the approach to a helipad at night.Aug 5, 2012 · N429PH · Minor damageNTSB CEN12LA591Accident · Serious injuriesLimited investigationFinal reportArbc Inc DBA Lindstrand 180A · Prairie du Sac, WIThe pilot's loss of control of the balloon during a landing in higher-than-expected wind conditions, which resulted in a hard landing.Aug 4, 2012 · N3013T · Minor damageNTSB CEN12FA561Accident · No injuriesField investigationFinal reportSavage Air Epic LT · San Saba, TXThe improper installation of flexible fuel lines, which resulted in a partial collapse of the inner wall of the fuel lines and a subsequent a loss of engine power due to fuel starvation.Aug 4, 2012 · N603JS · Substantial damageNTSB CEN12FA517Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Imperial, NEThe pilot’s failure to maintain adequate clearance from rising terrain while flying toward the rising sun, which interfered with his ability to see the terrain.Aug 4, 2012 · N36286 · Substantial damageNTSB WPR12CA343Accident · Minor injuriesData collectionFinal reportPiper PA-22-160 · White City, ORThe student pilot's attempt to keep the airplane airborne and continue the takeoff after the airplane bounced off the turf runway prematurely during the takeoff roll.Aug 3, 2012 · N9626D · Substantial damageNTSB ERA12CA496Accident · Minor injuriesData collectionFinal reportCessna 172S · Culpeper, VAThe pilot’s failure to maintain directional control during an attempted takeoff.Aug 3, 2012 · N6276Z · Substantial damageNTSB CEN12LA514Accident · Minor injuriesLimited investigationFinal reportWeatherly 620B · Holcomb, KSThe pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a partial loss of engine power shortly after takeoff.Aug 3, 2012 · N2008S · Substantial damageNTSB CEN12CA526Accident · Minor injuriesData collectionFinal reportCessna 172R · Leesville, LAThe student pilot's failure to properly re-configure the airplane for a go-around, which resulted in a runway excursion when he decided to land on the remaining runway.Aug 3, 2012 · N989BT · Substantial damageNTSB WPR12FA339Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Truckee, CAThe pilot’s failure to maintain control of the airplane during initial climb. Contributing to the accident was the pilot’s impairment by prescription pain medication.Aug 2, 2012 · N8218P · Substantial damageNTSB WPR12CA353Accident · No injuriesData collectionFinal reportCessna 182 · Joseph, ORThe pilot’s excessive use of brakes during the landing roll in a gusting crosswind, which resulted in a noseover.Aug 2, 2012 · N5418B · Substantial damageNTSB WPR12CA342Accident · Serious injuriesData collectionFinal reportPiper PA18 · McNeal, AZThe pilot's in-flight decision to fly at low level into an unfamiliar canyon, which resulted in an off-airport landing when the airplane's climb capability was exceeded. Contributing to the accident was the airplane’s decreased performance due to the high…Aug 2, 2012 · N2364P · Substantial damageNTSB WPR12CA340Accident · Minor injuriesData collectionFinal reportPiper PA-22-160 · McKinleyville, CAThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident were the pilot’s lack of experience in the accident airplane make and model and his lack of knowledge regarding the fuel system.Aug 2, 2012 · N3442Z · Substantial damage