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 CEN11CA624Accident · No injuriesData collectionFinal reportCessna 172S · Bemidji, MNThe student pilot's improper flare, which resulted in a hard landing.NTSB ANC11CA097Accident · No injuriesData collectionFinal reportPiper PA-12 · Anchorage, AKThe pilot's misidentification of the runway environment in dusk light conditions.NTSB ANC11CA095Accident · No injuriesData collectionFinal reportCessna 170A · Anchorage, AKThe fracture of a hydraulic brake line fitting due to incorrect installation of the brake line by the pilot/owner, which resulted in a loss of brake pressure and subsequent loss of directional control during the landing roll.NTSB ANC11CA094Accident · No injuriesData collectionFinal reportPiper PA-12 · North Pole, AKThe pilot's failure to maintain adequate airspeed during takeoff, resulting in an aerodynamic stall and collision with the water.NTSB WPR11LA471Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Phoenix, AZThe pilot's improper flare and hard landing, which resulted in the failure of the nose landing gear drag link in overstress.NTSB WPR11GA431Accident · Minor injuriesFinal reportBell 205 · Tehachapi, CAThe pilot's inability to adequately execute an emergency autorotation due to the flight's low altitude during external load operations, which resulted in a hard landing. Contributing to the accident was a torsionally overstressed tachometer shaft, which sent…NTSB WPR11FA430Accident · 2 fatalField investigationFinal reportCessna P210 · Tehachapi, CAThe pilot’s intentional low-altitude maneuvering and failure to maintain clearance from terrain due to distraction.NTSB WPR11FA429Accident · 1 fatalField investigationFinal reportBrewster LONG-EZ · Kanab, UTThe pilot's loss of airplane control during cruise flight.NTSB WPR11FA428Accident · 2 fatalField investigationFinal reportVeatch Kitfox · Caldwell, IDThe pilot’s failure to prevent a low-altitude stall and spin following a complete loss of engine power during the initial climb after takeoff.NTSB WPR11CA432Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Lancaster, CAThe student pilot’s inadequate flare resulting in a hard landing. Contributing to the accident was the certified flight instructor's inadequate supervision.NTSB ERA11LA484Accident · No injuriesLimited investigationFinal reportNorth American TB-25N · Georgetown, DEMaintenance personnel's inadequate examination of the main landing gear during the airplane’s most recent conditional inspection, which resulted in the fatigue failure of the right main landing gear shock strut drag arm during the landing roll.NTSB CEN11FA616Accident · 2 fatalField investigationFinal reportLarson Ken W Christen EAGLE-II · Seward, NEThe pilot’s inadvertent pulling of the mixture control lever on takeoff, which shut down the engine.NTSB CEN11CA677Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Monte Vista, COThe student pilot's loss of control while landing, which resulted in a ground loop.NTSB ANC11FA093Accident · Serious injuriesField investigationFinal reportPiper PA-18-150 · McGrath, AKThe pilot inadvertently switched off the engine magnetos during short final approach, which resulted in a loss of engine power. Contributing to the accident was the manufacturer's placement of the magneto switches in the cabin.NTSB ANC11CA092Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Deadhorse, AKThe pilot's continued visual flight into instrument meteorological conditions.NTSB WPR11LA427Accident · No injuriesLimited investigationFinal reportStinson V77 · Tillamook, ORThe pilot’s loss of directional control while taxiing in a gusting tailwind.NTSB WPR11FA426Accident · Serious injuriesField investigationFinal reportEnstrom 280FX · Heber City, UTThe pilot’s failure to ensure that there was sufficient fuel onboard to conduct the flight, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the severity of the passengers’ injuries was the operator’s failure to provide…NTSB WPR11CA433Accident · No injuriesData collectionFinal reportSherman Craig W Glasair III · Kanab, UTThe pilot’s failure to maintain directional control during the landing roll, as a result of a flat left main landing gear tire.NTSB WPR11CA425Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Gerlach, NVThe pilot’s decision to land at an unknown off-airport location.NTSB ERA11LA481Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · St. Petersburg, FLThe commercial pilot's improper recovery from a practice autorotation, resulting in a tailboom strike and subsequent rollover.NTSB CEN11CA689Accident · Minor injuriesData collectionFinal reportPiper J3L-65 · Gainesville, TXThe pilot’s failure to maintain directional control during taxi, which resulted in a runway excursion.NTSB CEN11CA684Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Fort Worth, TXThe certified flight instructor’s improper flare during a simulated emergency landing.NTSB WPR11FA424Accident · Serious injuriesField investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Lakeport, CAThe pilot's decision to continue the takeoff with reduced engine power, which resulted in a collision with terrain during the takeoff initial climb. Contributing to the accident was the partial loss of engine power for reasons that could not be determined…NTSB WPR11CA422Accident · No injuriesData collectionFinal reportAir Creation Clipper 582S · Enumclaw, WAThe pilot’s failure to maintain directional control during landing.NTSB ANC11FA091Accident · 1 fatalField investigationFinal reportCessna 208B · Nightmute, AKThe failure of the pilot of the other airplane to maintain adequate clearance while performing an unexpected and unannounced abrupt maneuver, resulting in a midair collision between the two airplanes.NTSB ERA11FA480Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Provincetown, MAThe pilot’s failure to maintain adequate clearance from trees and terrain during the initial climb. Contributing was spatial disorientation due to a vestibular illusion and the pilot’s likely impairment due to alcohol consumption.NTSB ERA11CA500Accident · Minor injuriesData collectionFinal reportSpectrum RX 550 · Hartland, MEA total loss of engine power due to fuel contamination.NTSB CEN11LA614Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Valparaiso, INThe pilot’s loss of directional control during landing. Contributing to the accident was the wear in the tailwheel assembly.NTSB CEN11IA615Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Baton Rouge, LAThe improperly installed upper attachment bolt in the left main landing gear uplock assembly, which led to the failure of the left main landing gear to extend before landing. Contributing to the accident was maintenance personnel's lack of training on the…NTSB CEN11CA670Accident · No injuriesData collectionFinal reportCessna 140 · Conroe, TXThe pilot's excessive use of brakes during the landing.NTSB CEN11CA613Accident · Minor injuriesData collectionFinal reportTaylorcraft DCO-65 · Higginsville, MOThe pilot's failure to maintain directional control during landing and his failure to maintain clearance from trees during the attempted aborted landing.NTSB WPR11CA419Accident · Minor injuriesData collectionFinal reportCessna TU206F · Bremerton, WAThe total loss of engine power as a result of fuel exhaustion due to the pilot's inadequate in-flight planning.NTSB ERA11LA489Accident · No injuriesLimited investigationFinal reportCessna 172N · Plymouth, MAThe pilot's inadequate flare and improper recovery from a bounced landing.NTSB ERA11CA517Accident · No injuriesData collectionFinal reportFantasy Air Sro Allegro 2000 · Stonington, METhe pilot's inadequate landing flare, which resulted in a hard landing during crosswind conditions.NTSB CEN11CA660Accident · No injuriesData collectionFinal reportCessna 175 · Sugar Creek, OHThe pilot's delayed application of carburetor heat while operating in conditions conducive to carburetor icing.NTSB CEN11CA611Accident · No injuriesData collectionFinal reportPiper L-21B · East Liverpool, OHThe pilot's failure to maintain directional control of the airplane during landing.NTSB WPR11CA418Accident · Minor injuriesData collectionFinal reportChristen Industries A-1 · Dorris, CAThe pilot’s failure to maintain lateral aircraft control while taking off with a gusting crosswind.NTSB CEN11CA609Accident · Minor injuriesData collectionFinal reportMooney M20C · Allen, OKA total loss of engine power in flight due to fuel starvation as a result of the pilot’s inadequate fuel management.NTSB ANC11CA089Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Cape Yakataga, AKThe pilot inadvertently switching off the engine magnetos during the initial climb, resulting in a loss of engine power. Contributing to the accident was the manufacturer's placement of the magneto switches.NTSB WPR11FA415Accident · Serious injuriesField investigationFinal reportCessna 172M · Santa Monica, CAThe student pilot’s misjudged approach and landing attempt. Contributing to the accident was a lack of airspeed due to a blocked pitot tube.NTSB WPR11CA414Accident · No injuriesData collectionFinal reportMaule M-6-235 · Hailey, IDThe pilot’s failure to maintain directional control during the landing rollout in a gusty, crosswind condition.NTSB WPR11CA413Accident · Minor injuriesData collectionFinal reportCessna 172F · Atlanta, IDThe pilot’s misjudgment of his final approach path. Contributing to the accident was the pilot’s inadequate preflight planning.NTSB CEN11LA601Accident · Minor injuriesLimited investigationFinal reportVan's RV-12 · Windom, MNThe pilot's loss of airplane control after liftoff due to his distraction with the unsecured canopy, which he did not lock before takeoff.NTSB CEN11CA638Accident · No injuriesData collectionFinal reportEnstrom F-28F · Menominee, MIThe pilot's failure to maintain control of the helicopter during a hover.NTSB CEN11CA604Accident · No injuriesData collectionFinal reportCessna 172M · Plymouth, MIThe pilot's failure to perform a go-around when the airplane was not in a position to make a safe landing and his excessive use of bank control during the landing attempt, which resulted in the wing striking the ground.NTSB WPR11LA412Accident · No injuriesLimited investigationFinal reportWheeler Vans RV-6A · Albany, ORThe in-flight separation of a propeller blade due to fatigue.NTSB WPR11LA410Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Napa, CAThe pilot’s mismanagement of the fuel supply, which resulted in a loss of engine power due to fuel starvation.NTSB WPR11CA411Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-32 · Warner Springs, CAThe pilot’s inadequate altitude to clear a ridgeline while maneuvering over a mountainous area.NTSB WPR11CA409Accident · Serious injuriesData collectionFinal reportCessna 170A · Grangeville, IDThe pilot's loss of directional control for undetermined reasons.NTSB CEN11LA688Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Berryville, TXThe pilot did not maintain control of the airplane during a forced landing, which resulted in an aerodynamic stall. Contributing to the accident was the loss of engine power for undetermined reasons.