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 OPS11IA686Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-83(MD-83) · Apache Junction, AZThe failure of the pilots of both airplanes to see and avoid each other and to maneuver as advised by the air traffic controller in time to prevent the conflict that resulted in the reported near midair collision.Jun 27, 2011 · N416NV · No damageNTSB ERA11LA370Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Holly Springs, MSThe pilot's incorrect positioning of the fuel tank selector before takeoff, which resulted in a loss of engine power due to fuel starvation during takeoff initial climb.Jun 27, 2011 · N759ZS · Substantial damageNTSB ANC11FA055Accident · 1 fatalField investigationFinal reportCessna 150M · Beluga Lake, AKThe pilot did not maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall.Jun 27, 2011 · N66286 · Substantial damageNTSB ANC11CA057Accident · No injuriesData collectionFinal reportDehavilland DHC-2 MK 1 · Talkeetna, AKThe pilot's selection of unsuitable terrain for takeoff.Jun 27, 2011 · N561TA · Substantial damageNTSB ANC11CA056Accident · No injuriesData collectionFinal reportHughes 500D · Ambler, AKThe pilot's misalignment of the helicopter on the landing structure.Jun 27, 2011 · C-GLHQ · Substantial damageNTSB WPR11LA313Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Flagstaff, AZFatigue failure of an engine mount attachment foot, which resulted in collapse of the nose landing gear during landing. Contributing to the accident was the failure of the owner/operator to adhere to the manufacturer's suggested engine mount inspection…Jun 26, 2011 · N9246M · Substantial damageNTSB WPR11LA289Accident · Serious injuriesLimited investigationFinal reportLemond FLY Fisher · West Glacier, MTA total loss of engine power during takeoff due to water contamination in the fuel system. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane.Jun 26, 2011 · N397JL · Substantial damageNTSB WPR11LA287Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · St Johns, AZThe pilot did not attain and maintain an adequate airspeed during the takeoff initial climb, which resulted in an aerodynamic stall.Jun 26, 2011 · N2725V · Substantial damageNTSB WPR11CA294Accident · No injuriesData collectionFinal reportCessna 172N · Olympia, WAThe pilot's failure to maintain clearance from obstacles.Jun 26, 2011 · N5366J · Substantial damageNTSB ERA11LA361Accident · No injuriesLimited investigationFinal reportBeech A60 · Pompano Beach, FLThe pilots of both airplanes did not maintain adequate visual lookout during taxi, which resulted in an on-ground collision.Jun 26, 2011 · N38N · 2 aircraft · Minor damageNTSB ERA11FA360Accident · 1 fatalField investigationFinal reportClabaugh Robert R Barracuda · Andalusia, ALThe pilot did not maintain airspeed while maneuvering on approach for landing, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of experience in the make and model airplane.Jun 26, 2011 · N289DH · Substantial damageNTSB ERA11CA365Accident · Serious injuriesData collectionFinal reportPiper PA-32-300 · Bridgeport, CTThe pilot's failure to maintain clearance from a blast fence on final approach to land.Jun 26, 2011 · N600DK · Substantial damageNTSB ERA11CA363Accident · Minor injuriesData collectionFinal reportCessna 150L · Winter Haven, FLThe certified flight instructor's failure to maintain control during the attempted go-around, which resulted in an aerodynamic stall.Jun 26, 2011 · N18735 · Substantial damageNTSB CEN11FA425Accident · 1 fatalField investigationFinal reportCessna T210L · Romeoville, ILA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.Jun 26, 2011 · N732BX · Substantial damageNTSB CEN11FA420Accident · 1 fatalField investigationFinal reportLuscombe 8A · Farmdale, OHThe pilot's decision to initiate an aerobatic maneuver at an altitude that did not allow for full recovery of the airplane before ground impact.Jun 26, 2011 · N71687 · Substantial damageNTSB WPR11CA293Accident · No injuriesData collectionFinal reportAviat A-1B · Livermore, CAThe pilot's failure to maintain directional control during a go-around.Jun 25, 2011 · N101HY · Substantial damageNTSB ERA11CA364Accident · Minor injuriesData collectionFinal reportHelio H-295 · Brasstown, NCThe pilot's inadequate preflight planning, which resulted in a loss of engine power due to fuel exhaustion.Jun 25, 2011 · N99PM · Substantial damageNTSB CEN11LA426Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · New Philadelphia, OHThe pilot's incorrect identification of the wind direction before landing, which resulted in a tailwind landing and subsequent runway excursion.Jun 25, 2011 · N6980W · Substantial damageNTSB CEN11LA419Accident · No injuriesLimited investigationFinal reportVanDenburg Pietenpol Air Camper · Gwinn, MIThe pilot’s loss of directional control during the landing roll, which resulted in a ground loop.Jun 25, 2011 · N16DV · Substantial damageNTSB CEN11LA418Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Rantoul, ILThe pilot did not use the emergency landing gear extension system, which resulted in a wheels-up landing. Contributing to the accident was the inoperative landing gear power pack motor.Jun 25, 2011 · N4106Q · Substantial damageNTSB WPR11LA283Accident · No injuriesLimited investigationFinal reportBeech A36 · El Monte, CAThe pilot's failure to maintain adequate airspeed during the forced landing, which resulted in an aerodynamic stall and hard landing. Contributing to the accident was the loss of engine power due to fuel starvation as a result of the pilot's improper fuel…Jun 24, 2011 · N2206L · Substantial damageNTSB WPR11CA286Accident · No injuriesData collectionFinal reportAir Tractor AT301 · Circle, MTThe pilot's failure to attain and maintain an adequate airspeed during initial climb.Jun 24, 2011 · N2362D · Substantial damageNTSB CEN11FA417Accident · 2 fatalField investigationFinal reportBeech A36 · Charlevoix, MIThe pilot's inadequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to not execute a missed approach in weather conditions below minimums.Jun 24, 2011 · N88MN · Substantial damageNTSB CEN11CA438Accident · No injuriesData collectionFinal reportCessna A188 · Castroville, TXThe pilot's failure to maintain obstacle clearance during the agricultural spraying flight.Jun 24, 2011 · N731ST · Substantial damageNTSB WPR11CA281Accident · No injuriesData collectionFinal reportPiper PA-36-285 · Havre, MTThe pilot's failure to maintain directional control during takeoff.Jun 23, 2011 · N57736 · Substantial damageNTSB ERA11LA359Accident · Serious injuriesLimited investigationFinal reportNavion Navion B · Red Oak, NCThe pilot's inadvertent movement of the fuel tank selector handle to the off position, resulting in a total loss of engine power due to fuel starvation.Jun 23, 2011 · N75394 · Substantial damageNTSB ERA11LA357Accident · No injuriesLimited investigationFinal reportCessna 182F · Warrenton, VAThe fatigue failure of the left main landing gear due to inadequate maintenance inspection that did not detect and correct corrosion pitting.Jun 23, 2011 · N3152U · Substantial damageNTSB ERA11FA354Accident · 2 fatalField investigationFinal reportBeech C24R · Valparaiso, FLThe pilots’ failure to maintain airspeed, which resulted in an inadvertent, low altitude aerodynamic stall.Jun 23, 2011 · N38029 · Substantial damageNTSB CEN11LA414Accident · No injuriesLimited investigationFinal reportEnstrom F-28C-2 · Blair, NEThe failure of a tail rotor pitch change link due to the retaining bolt becoming separated in flight. Contributing to the accident was the pilot’s inadequate preflight inspection.Jun 23, 2011 · N5694A · Substantial damageNTSB ANC11CA054Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Nikiski, AKThe pilot's improper use of brakes during landing.Jun 23, 2011 · N6248R · Substantial damageNTSB WPR11LA280Accident · No injuriesLimited investigationFinal reportInhofe/ Davis Vans RV-8 · Sheridan, WYThe pilot's inadequate directional control during the landing roll.Jun 22, 2011 · N4546Y · Substantial damageNTSB CEN11LA421Accident · 2 fatalLimited investigationFinal reportUltralight America Spitfire II · Ranger, TXThe pilot’s failure to maintain sufficient airspeed during the initial climb after a takeoff in high density altitude conditions, which resulted in an inadvertent stall.Jun 22, 2011 · N6524R · DestroyedNTSB WPR11TA274Accident · No injuriesFinal reportBell 206B · Franklin, CAThe student pilot's failure to maintain rotor rpm during the practice autorotation.Jun 21, 2011 · N38EA · Substantial damageNTSB WPR11LA292Accident · No injuriesLimited investigationFinal reportCessna 320F · Phoenix, AZThe mechanic's failure to properly secure the nose landing gear actuator push-pull tube to the landing gear door hinge clevis, which resulted in the gear jamming and not fully retracting after takeoff.Jun 21, 2011 · N6160Q · Substantial damageNTSB WPR11LA277Accident · Serious injuriesLimited investigationFinal reportBell 212 · Mesa, AZThe pilot's failure to maintain helicopter control while in a low hover.Jun 21, 2011 · N49678 · DestroyedNTSB WPR11LA272Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Hogeland, MTCollision with the ground while maneuvering at low altitude for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Jun 21, 2011 · N3661B · Substantial damageNTSB WPR11CA271Accident · No injuriesData collectionFinal reportLuscombe 8F · McCall, IDThe pilot's failure to maintain adequate airspeed that resulted in a stall/mush. Contributing to the accident was the pilot's failure to maintain an adequate spacing from the aircraft ahead of him.Jun 21, 2011 · N1459B · Substantial damageNTSB WPR11FA268Accident · 1 fatalField investigationFinal reportTrusty Thorp T-18 · Tehachapi, CAThe pilot’s failure to maintain clearance from mountainous terrain during cruise flight, which resulted from his impairment or incapacitation due to multiple medical conditions and sedating medication.Jun 20, 2011 · N851LT · Substantial damageNTSB ERA11CA358Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Linwood, NJThe pilot's improper brake application during the landing roll which resulted in a nose over.Jun 20, 2011 · N87020 · Substantial damageNTSB ERA11CA355Accident · No injuriesData collectionFinal reportDotson William P Sngl Seat Hawk Arrow · Carthage, NCA partial loss of engine power due to the pilot’s improper installation of the engine’s No. 1 cylinder spark plugs.Jun 20, 2011 · N4209F · Substantial damageNTSB ANC11CA052Accident · No injuriesData collectionFinal reportCessna 182H · Soldotna, AKThe pilot's failure to maintain pitch control resulting in an aerodynamic stall.Jun 20, 2011 · N331AA · Substantial damageNTSB WPR11LA270Accident · 1 fatalLimited investigationFinal reportSix Chuter Skye Ryder Aerochute · Tooele, UTThe operation of a powered parachute by a non-certificated pilot. Contributing to the accident was the pilot's decision to conduct a flight in a strong gusty wind.Jun 19, 2011 · UNREG · Substantial damageNTSB WPR11LA267Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Lost Hills, CAThe failure of the engine-driven fuel pump, resulting in the loss of all engine power and the pilot's failure to correctly execute an autorotational landing.Jun 19, 2011 · N138HA · Substantial damageNTSB OPS11IA673Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145EP · Gulfport, MSthe Gulfport control tower local controller cleared two aircraft for takeoff from runways with intersecting departure flight paths without ensuring the first aircraft had passed the flight path intersection prior to clearing the second aircraft for takeoff.Jun 19, 2011 · N13929 · 2 aircraft · No damageNTSB ERA11CA371Accident · No injuriesData collectionFinal reportCessna 172M · North Adams, MAThe pilot's inadequate visual lookout and subsequent failure to maintain clearance from a light pole while taxiing.Jun 19, 2011 · N12477 · Substantial damageNTSB ERA11CA352Accident · No injuriesData collectionFinal reportPiper PA18-160 · Ridgeville, SCA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.Jun 19, 2011 · N177SC · Substantial damageNTSB CEN11FA401Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Columbus, OHThe pilot's spatial disorientation during the takeoff into instrument meteorological conditions, which resulted in his failure to maintain control of the airplane.Jun 19, 2011 · N526PG · DestroyedNTSB CEN11CA409Accident · No injuriesData collectionFinal reportCessna 172N · Santa Teresa, NMThe pilot's inadequate compensation for the wind condition, resulting in a runway excursion.Jun 19, 2011 · N739ZN · Substantial damageNTSB WPR11LA266Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Mount Pleasant, UTThe pilot’s failure to determine the airplane’s fuel quantity before takeoff, which resulted in a loss of engine power due to fuel exhaustion.Jun 18, 2011 · N65654 · Substantial damageNTSB WPR11LA263Accident · No injuriesLimited investigationFinal reportBeech B23 · Jean, NVThe student pilot’s improper in-flight fuel management when he did not switch to the fullest fuel tank when the engine began to lose power, which resulted in fuel starvation and the complete loss of engine power during maneuvering flight. Contributing to the…Jun 18, 2011 · N6991Q · Substantial damage