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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CEN14FA300Accident · 3 fatalField investigationFinal reportPiper PA 46-310P · Lehman, TXThe pilot's improper decision to enter an area of known adverse weather, which resulted in the loss of airplane control. Contributing to the accident was the air traffic controller's failure to provide critical weather information to the pilot to help him…NTSB CEN14CA303Accident · Minor injuriesData collectionFinal reportPiper PA 28-180 · Port Isabel, TXA loss of engine power due to the pilot's improper inflight planning and reliance of fuel gauge readings, which resulted in fuel exhaustion.NTSB ANC14CA042Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Coldfoot, AKThe pilot's failure to maintain adequate main rotor rpm while maneuvering at a low altitude, which resulted in an emergency landing on uneven terrain.NTSB WPR14LA251Accident · No injuriesLimited investigationFinal reportAirbus AS 350 BA FX1 · Wailuku, HIThe failure of the engine’s pneumatic fuel control line fitting, resulting in a loss of engine power. Contributing to the failure was the repeated loosening and re-torqueing of the fitting during required maintenance and inspection.NTSB WPR14FA231Accident · 1 fatalField investigationFinal reportGrumman G 21A · Sula, MTThe pilot's decision to continue flight into deteriorating weather conditions in an airplane not maintained for instrument flight, which resulted in a loss of control due to spatial disorientation.NTSB ERA14LA295Accident · No injuriesLimited investigationFinal reportMaule M4-220C · Cherryville, NCThe pilot’s improper landing flare, which resulted in a hard landing and subsequent main landing gear collapse.NTSB ERA14LA293Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C-1 · Allentown, PAInadequate inspection and maintenance of the helicopter’s landing gear dampers, which resulted in ground resonance during helicopter shutdown.NTSB ERA14FA292Accident · 1 fatalField investigationFinal reportColumbia Aircraft Mfg LC41 550FG · East Patchogue, NYThe noninstrument-rated pilot's encounter with instrument meteorological conditions and his decision to continue visual flight rules flight in instrument conditions, which resulted in a loss of control due to spatial disorientation.NTSB DCA14CA124Accident · Serious injuriesData collectionFinal reportBoeing 767 424ER · Newark, NJA hot liquid splashed from a meal box onto the flight attendant's hand, resulting in a 2nd degree burn.NTSB CEN14LA296Accident · Minor injuriesLimited investigationFinal reportBell 206B · Decatur, TXThe flight instructor’s improper recovery from a practice autorotation, which resulted in a hard landing.NTSB WPR14CA247Accident · No injuriesData collectionFinal reportCessna 180 · Casper, WYThe pilot's inadequate flare and loss of directional control during landing.NTSB ERA14LA302Accident · Minor injuriesLimited investigationFinal reportBailey Robert Moyes Dragonfly · Melfa, VAThe pilot’s failure to maintain roll control during the initial takeoff and his decision to take off with only partial power applied.NTSB CEN14LA299Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT 502 · Dell, ARThe pilot’s failure to establish a proper airspeed during takeoff with the airplane near its maximum gross weight in high-density altitude and gusting crosswind conditions.NTSB CEN14LA293Accident · No injuriesLimited investigationFinal reportKnauf RV-7 · Rockwall, TXThe pilot's failure to verify the airplane's actual fuel quantity before departure, which resulted in a total loss of engine power due to fuel exhaustion and the subsequent forced landing.NTSB CEN14CA302Accident · No injuriesData collectionFinal reportCessna 180 · Springview, NEThe pilot's failure to maintain directional control of the airplane while landing in a crosswind. Contributing to the accident was the gusty crosswind.NTSB CEN14CA295Accident · Minor injuriesData collectionFinal reportCessna 414 · Pleasanton, TXThe pilot's failure to maintain aircraft control during an aborted landing due to an encounter with a tailwind.NTSB WPR14LA249Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Quincy, CAThe partial loss of engine power during takeoff due to the separation of the exhaust baffling, which resulted in a partial blockage of airflow to the engine. Contributing to the accident was maintenance personnel’s inadequate inspection of the exhaust system…NTSB WPR14FA244Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA 5B · Florence, ORThe noninstrument-rated pilot’s visual flight into instrument meteorological conditions, which resulted in his spatial disorientation and the subsequent loss of airplane control.NTSB ERA14LA290Accident · 1 fatalLimited investigationFinal reportCameron Balloons US Z-225 · Spring City, PAThe pilot's fall from the balloon’s basket during touchdown in a field for reasons that could not be determined based on the available evidence, which resulted in his fatal injury.NTSB CEN14CA355Accident · No injuriesData collectionFinal reportCessna 182S · Put in Bay, OHThe pilot's improper flare, which resulted in a hard landing.NTSB ERA14CA310Accident · No injuriesData collectionFinal reportJackson Fred M Clipper · Altamont, NYThe pilot's failure to apply carburetor heat prior to descending in atmospheric conditions conducive to serious icing at all power settings, which resulted in a total loss of engine power.NTSB ERA14CA298Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Milton, FLThe pilot's failure to maintain the proper approach path, and his delayed remedial action, which resulted in a runway undershoot and collision with terrain prior to the runway.NTSB CEN14CA289Accident · No injuriesData collectionFinal reportCessna 182A · Valmeyer, ILThe inadvertent deployment of the skydiver's drogue chute when he exited the airplane, resulting in it contacting and damaging the horizontal stabilizer.NTSB WPR14FA243Accident · 2 fatalField investigationFinal reportDittenber Thomas J Auriga · Echo Bay, NVThe pilot's failure to maintain airplane control while maneuvering for landing to an unlit runway in dark night conditions.NTSB WPR14CA246Accident · No injuriesData collectionFinal reportPiper PA 22-160 · Jackson, MTThe pilot's failure to maintain directional control of the airplane during landing roll.NTSB ERA14FA289Accident · 1 fatalField investigationFinal reportMeyer Clair O 2/3 P 51B/C Mustang · Marion, SCThe airplane's impact with terrain shortly after takeoff due to a physiological incapacitation of the pilot.NTSB ERA14FA288Accident · 1 fatalField investigationFinal reportPiper PA-46-500TP · White Plains, NYThe pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation (somatogravic illusion). Contributing to the accident was the pilot's self-induced pressure to depart and his decision to depart in low-ceiling and…NTSB ERA14CA307Accident · No injuriesData collectionFinal reportBeech 58 · Tupelo, MSThe pilot's inadvertent retraction of the landing gear on the runway, which resulted in a landing gear collapse.NTSB ERA14CA291Accident · No injuriesData collectionFinal reportCessna 172B · Frankfort, KYThe pilot's failure to maintain directional control during landing in crosswind conditions, resulting in a loss of control and runway excursion.NTSB ERA14IA301Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Burlington, MAA loss of clamping load of the No. 5 cylinder crankcase through bolts due to maintenance personnel’s failure to properly torque the through bolts during recent maintenance, which resulted in displacement of the No. 2 bearing and the subsequent catastrophic…NTSB CEN14LA284Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Winner, SDThe pilot's improper decision to attempt a takeoff with a tailwind and his failure to achieve the proper airspeed for liftoff, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall shortly after liftoff.NTSB CEN14FA286Accident · 2 fatalField investigationFinal reportBell 206 L4 · South Timbalier PlatformThe pilot's loss of helicopter control for reasons that could not be determined based on the available information.NTSB ANC14LA041Accident · No injuriesClass 3 · LimitedFinal reportAirbus/Eurocopter AS 350 B3 · Anchorage, AKThe pilot’s improper engine start procedure, which resulted in an overspeed of the engine and main rotor drive system.NTSB ERA14FA283Accident · 2 fatalField investigationFinal reportCessna 172S · Daytona Beach, FLA partial loss of engine power during the initial climb after takeoff for reasons that could not be determined due to the postaccident condition of the wreckage. Contributing to the accident was the pilots' decision to turn back to the airport, which led to…NTSB ERA14FA282Accident · 2 fatalField investigationFinal reportLiberty Aerospace XL-2 · Merritt Island, FLThe failure of the pilots to maintain airspeed while maneuvering, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the loss of engine power for a reason that could…NTSB CEN14LA537Accident · Minor injuriesLimited investigationFinal reportHughes TH 55A · Hudson, WIThe nonhelicopter-rated pilot’s operation of the helicopter and its subsequent collision with trees during takeoff for reasons that could not be determined based on the available evidence.NTSB WPR14FA239Accident · 2 fatalField investigationFinal reportAmerican AA-1A · El Mirage, CAThe pilot's loss of airplane control while intentionally maneuvering close to the ground, which resulted in the airplane exceeding its critical angle of attack in a steep bank and entering an accelerated stall.NTSB WPR14TA236Accident · No injuriesFinal reportMcdonnell Douglas Helicopter 369E · Mesa, AZThe loss of engine power during cruise flight due to the decoupling of the engine’s turbine and compressor sections. Contributing to the decoupling was the excessive wear of the turbine-to-compressor coupling components due maintenance personnel’s placement…NTSB WPR14LA235Accident · No injuriesLimited investigationFinal reportCessna 172N · Page, AZThe pilot’s improper landing flare in gusting wind conditions, his inadequate recovery from the subsequent bounced landing, and his decision to perform a go-around with insufficient airspeed to climb.NTSB ERA14LA281Accident · Serious injuriesLimited investigationFinal reportBelew Marshall D II Steen Skybolt · Chapmansboro, TNThe pilot's failure to maintain airspeed while performing an emergency landing, which led to the airplane exceeding its critical angle-of-attack and experiencing a subsequent aerodynamic stall. Contributing to the accident was a partial loss of engine power…NTSB ERA14CA280Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Reading, PAThe pilot's loss of control while landing the tailwheel-equipped airplane in a quartering tailwind. A factor in the accident was the changing wind conditions.NTSB CEN14FA288Accident · 2 fatalField investigationFinal reportSchrieber Robert L P 70 · Great Bend, KSThe pilot's improper preflight planning, which led to a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's loss of airplane control during the forced landing.NTSB WPR14LA233Accident · 1 fatalLimited investigationFinal reportNorth Wing Apache Sport · Polson, MTThe pilot’s loss of airplane control during initial climb due to his experiencing an incapacitating medical event.NTSB WPR14FA234Accident · 2 fatalField investigationFinal reportPiper J3C · Paso Robles, CAThe pilot's steep right turn shortly after takeoff, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB WPR14CA241Accident · No injuriesData collectionFinal reportCessna 180H · Hesperia, CAThe pilot's failure to maintain directional control during the landing roll.NTSB ERA14LA285Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Newport, VTThe pilot's failure to maintain adequate airspeed during an aborted landing, which resulted in an aerodynamic stall and collision with the ground. Contributing to the accident was the pilot's alcohol impairment.NTSB CEN14LA298Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Oneida, ARThe pilot’s inadequate fuel management, which resulted in a total loss of engine power at low altitude due to fuel exhaustion and a forced landing in a muddy field and subsequent nose-over.NTSB CEN14FA278Accident · 1 fatalField investigationFinal reportHermann Bjorn Lancair IV · Duluth, MNThe pilot's failure to maintain airplane control while operating in instrument flight rules (IFR) conditions, which was due to spatial disorientation resulting from erroneous heading and bank angle information shown on the primary flight display. Contributing…NTSB CEN14CA283Accident · No injuriesData collectionFinal reportAyres S2R T34 · Wilmont, ARPilot's failure to verify the amount of chemical load on the airplane prior to takeoff which resulted in the airplane being heavier than expected. Contributing to the accident was loading crew not following the pilot's instructions.NTSB ANC14LA039Accident · No injuriesLimited investigationFinal reportCessna 180H · Wasilla, AKThe pilot’s failure to maintain directional control during landing and an attempted go-around, which resulted in collision with terrain.