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 GAA17CA575Accident · No injuriesData collectionFinal reportSilvaire 8 · Texarkana, ARThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA564Accident · No injuriesData collectionFinal reportBoeing PT 13 · Skagit, WAThe pilot’s failure to maintain clearance from airport lighting during the landing roll.NTSB ERA17LA341Accident · No injuriesLimited investigationFinal reportCessna 162 · Huntsville, ALThe flight instructor’s failure to use carburetor heat, which resulted in the total loss of engine power due to carburetor icing.NTSB ERA17FA339Accident · 1 fatalField investigationFinal reportHickox Andy Andys Gyroplane · Umatilla, FLThe pilot's improper response to a total loss of engine power, which resulted in main rotor blade contact with the rudder and vertical stabilizer, and a subsequent uncontrolled descent. The loss of engine power was due to the separation of the electrical…NTSB GAA17CA572Accident · No injuriesData collectionFinal reportCub Crafters CC19-180 · Kalispell, MTThe pilot’s inadvertent brake application during the landing roll, which resulted in a loss of directional control.NTSB GAA17CA562Accident · Minor injuriesData collectionFinal reportEurocopter AS 350 · Fullerton, CAThe pilot under evaluation’s failure to maintain adequate airspeed during a simulated hydraulic failure, which resulted in a loss of helicopter control. Contributing to the accident was the check pilot’s delayed remedial action.NTSB GAA17CA561Accident · No injuriesData collectionFinal reportAmerican Legend AL18 · Bessemer, ALThe student pilot’s incorrect application of the brakes and subsequent failure to maintain directional control during the landing roll. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB GAA17CA560Accident · Minor injuriesData collectionFinal reportPiper J5A · Geneseo, NYThe pilot's failure to properly secure the airplane before a hand propeller start, which resulted in the airplane moving forward and colliding with maintenance equipment.NTSB GAA17CA559Accident · No injuriesData collectionFinal reportCessna 182 · San Diego, CAThe airplane’s inadvertent entry into instrument meteorological, dark night conditions and the pilot’s failure to maintain an adequate approach for landing.NTSB ERA17LA336Accident · No injuriesLimited investigationFinal reportCessna 152 · Winder, GAThe pilot's inadequate preflight inspection, which resulted in undetected water in the fuel system and a total loss of engine power during the initial climb.NTSB WPR17LA217Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Los Angeles, CAThe pilot's failure to extend the landing gear before landing.NTSB GAA17CA565Accident · No injuriesData collectionFinal reportPiper PA18 · Holy Cross, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a nose-over.NTSB GAA17CA557Accident · Minor injuriesData collectionFinal reportBellet James J Vans RV 8 · Orange, MAThe pilot's failure to remove the engine cowl plugs during preflight, which resulted in excessive engine cylinder head temperatures during climb and a total loss of engine power.NTSB WPR17LA216Accident · No injuriesLimited investigationFinal reportCessna 172P · TamuningThe pilot's inadequate preflight inspection, which resulted in oil exhaustion and a subsequent total loss of engine power during cruise flight.NTSB GAA17CA569Accident · No injuriesData collectionFinal reportPiper PA 18 · Beluga, AKThe pilot’s inability to maintain pitch control due to an encounter with a tailwind gust after the airplane had stopped, which resulted in a nose-over.NTSB DCA17CA217Accident · Serious injuriesData collectionFinal reportBoeing 737-8H4 · Sioux City, IAthe flight attendant accidentally pouring hot water on his hand which resulted in a 2nd degree burn.NTSB CEN17LA368Accident · 1 fatalLimited investigationFinal reportEris E. Ervin Quicksilver · Cleburne, TXAn engine loss of power due to fuel starvation from a broken fuel line between the fuel tank and the engine; the loss of engine power prevented the pilot from reaching a suitable landing area. Contributing to the accident was the inadequate maintenance of the…NTSB GAA17CA553Accident · No injuriesData collectionFinal reportAerotrike Safari · Bridgeton, NJThe pilot’s improper landing flare, which resulted in a hard landing while conducting an off-airport precautionary landing after a bird strike.NTSB GAA17CA551Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Santa Barbara, CAThe student pilot’s unstabilized hover, which resulted in ground contact and a dynamic rollover. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB ERA17LA333Accident · Serious injuriesLimited investigationFinal reportBuschmann/Vanzee Vari EZ · Ambler, PAWater contamination of the fuel that was not detected during a preflight inspection, which resulted in a total loss of engine power.NTSB CEN17FA364Accident · 2 fatalField investigationFinal reportBeech C35 · Camden, ARThe pilot's improper decision to return to the runway instead of landing straight ahead when the engine lost power and his failure to maintain adequate airspeed while maneuvering for an emergency landing, which resulted in an exceedance of the airplane's…NTSB WPR17LA214Accident · No injuriesLimited investigationFinal reportSC Aerostar YAK 52W · El Cajon, CAThe pilot's failure to maintain directional control during taxi after a reduction in braking performance and steering capabilities due to his failure to reopen the air supply valve after the nonstandard engine start.NTSB WPR17LA212Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Glendale, CAThe pilot’s inadequate preflight fuel planning and improper decision to not refuel before the flight, which resulted in fuel exhaustion and the subsequent total loss of engine power.NTSB ERA17LA332Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 · Clearwater, FLThe airplane pilot's inadequate visual lookout, which resulted in an in-flight collision with a helicopter. Contributing to the accident was the airplane pilot's failure to adequately transmit his position while operating in the airport traffic pattern.NTSB CEN17FA362Accident · 1 fatalField investigationFinal reportMitsubishi MU 2B-40 · Ainsworth, NEThe pilot's loss of airplane control due to spatial disorientation.NTSB CEN17FA361Accident · 3 fatalField investigationFinal reportCessna TR182 · Thief River Falls, MNThe noninstrument-rated pilot's decision to depart into instrument meteorological conditions, and his subsequent loss of control due to spatial disorientation.NTSB WPR17FA213Accident · 2 fatalField investigationFinal reportCessna 172L · Perkinsville, AZThe pilot's decision to fly into a canyon during wind conditions conducive to turbulence and downdrafts, and his subsequent loss of aircraft control while maneuvering in the canyon. Contributing to the accident was the pilot's limited canyon flying experience.NTSB GAA17CA550Accident · No injuriesData collectionFinal reportCessna 180 · Danbury, CTThe pilot's failure to maintain directional control during the landing roll in gusting wind conditions.NTSB GAA17CA555Accident · No injuriesData collectionFinal reportGodwin Jeff E Safari · Fayetteville, NCThe student pilot’s failure to maintain lateral control during a hover pedal turn.NTSB GAA17CA554Accident · Minor injuriesData collectionFinal reportThomas J Murray Kitfox Super Sport · Old Forge, NYThe separation of the wheel assembly during landing due to the pilot’s use of improper retaining nuts when he installed the tundra tires.NTSB GAA17CA547Accident · No injuriesData collectionFinal reportCessna 180 · Albuquerque, NMThe pilot’s failure to maintain directional control during the takeoff roll in gusting crosswind conditions.NTSB DCA17IA202Incident · No injuriesIncident investigationFinal reportDJI Phantom · Hoffman Island, NYthe failure of the sUAS pilot to see and avoid the helicopter due to his intentional flight beyond visual line of sight. Contributing to the incident was the sUAS pilot's incomplete knowledge of the regulations and safe operating practices.NTSB WPR17LA211Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 · Long Beach, CAThe student pilot's failure to maintain rotor rpm during the crosswind landing approach and his subsequent improper decision to initiate an autorotation instead of applying corrective control inputs after the helicopter experienced normal airframe vibration.…NTSB GAA17CA546Accident · No injuriesData collectionFinal reportCessna 150 · Siler City, NCThe pilot's improper decision to take off with known electrical issues, which distracted him and led to a loss of directional control during the takeoff roll.NTSB GAA17CA543Accident · No injuriesData collectionFinal reportCessna T210 · St George, UTThe pilot’s failure to extend the landing gear before landing.NTSB ERA17FA330Accident · 1 fatalField investigationFinal reportCessna 150G · Rhine, GAThe student pilot's decision to take off from a partially-lit grass runway in dark night, marginal visual flight rules conditions, which resulted in spatial disorientation, an exceedance of the airplane's critical angle of attack, and an aerodynamic stall.NTSB WPR17LA209Accident · No injuriesLimited investigationFinal reportTrudel GP 4 · Reno, NVThe other pilot's failure to maintain clearance from the airplane during the line-abreast formation.NTSB WPR17LA208Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-161 · El Cajon, CAA partial loss of engine power due to the formation of carburetor ice during descent for landing. Contributing to the accident was the pilot’s failure to apply carburetor heat.NTSB WPR17LA206Accident · Minor injuriesClass 3 · LimitedFinal reportBell 47G 5 · Salinas, CAThe pilot’s inadequate visual lookout, which resulted in an in-flight collision with a wire.NTSB GAA17CA539Accident · No injuriesData collectionFinal reportCessna A185 · Talkeetna, AKThe pilot’s failure to maintain directional control while landing in gusting wind conditions.NTSB CEN17LA358Accident · No injuriesLimited investigationFinal reportCessna 177B · London, OHThe flight instructor's inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR17LA207Accident · No injuriesLimited investigationFinal reportCessna 208B · Sedona, AZThe pilot's failure to maintain clearance from a light pole while taxiing.NTSB GAA17CA556Accident · No injuriesData collectionFinal reportCessna 172 · Gallatin, TNThe student pilot’s improper landing flare, which resulted in a bounced landing.NTSB GAA17CA540Accident · No injuriesData collectionFinal reportCessna 172 · Lynchburg, VAThe pilot's unstabilized approach, which resulted in an aborted go-around, an aerodynamic stall, and a hard landing.NTSB ERA17LA328Accident · Minor injuriesLimited investigationFinal reportPiper J3C · Hanover Township, PAThe pilot's failure to maintain roll control while maneuvering, which resulted in a collision with trees and terrain.NTSB ERA17FA327Accident · 2 fatalField investigationFinal reportMooney M20C · North Branford, CTA total loss of engine power due to fuel starvation as the result of foreign object debris in the fuel selector valve. Contributing to the accident was the pilot's selection of a low cruising altitude, which reduced the available time to troubleshoot the loss…NTSB CEN17FA355Accident · 1 fatalField investigationFinal reportBell 206L 3 · Ancho, NMThe pilot's distraction by a cell phone during a low-altitude flight, which resulted in controlled flight into terrain.NTSB CEN17FA354Accident · 4 fatalField investigationFinal reportCirrus Design SR22 · Glenwood Springs, COThe non-instrument-rated pilot's inadequate preflight weather planning, his decision to depart into forecast instrument meteorological conditions along the route of flight, and his continued visual flight into instrument meteorological conditions, which…NTSB WPR17LA204Accident · No injuriesClass 3 · LimitedFinal reportCessna T210N · Watsonville, CAThe pilot’s improper landing flare, which resulted in a bounced landing and subsequent nose gear separation.NTSB GAA17CA579Accident · No injuriesData collectionFinal reportBeech 95 B55 · Statesville, NCThe pilot’s failure to maintain pitch control of the airplane during landing, which resulted in a bounced landing.