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 ERA21LA067Accident · No injuriesClass 4 · LimitedFinal reportPiper PA23 · Milton, FLThe pilot’s failure to attain a proper touchdown point and his landing with a high approach speed, which resulted in a runway overrun.NTSB ERA21LA065Incident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Leesburg, VAThe pilot’s loss of directional control during landing in crosswind conditions. Contributing to the loss of control was the significantly underinflated nose landing gear tire.NTSB ERA21LA062Accident · No injuriesClass 3 · LimitedFinal reportErcoupe 415 · South Boston, VAThe improper installation of a fuel filter screen cover gasket, which resulted in its failure, fuel starvation, and a subsequent total loss of engine power during cruise flight. Contributing to the accident was the unapproved fuel sight gauge, which obscured…NTSB CEN21LA075Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA32 · Windom, MNThe pilot’s spatial disorientation shortly after takeoff into night instrument meteorological conditions, which resulted in loss of airplane control and subsequent impact with terrain.NTSB CEN21LA077Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Marietta, TXThe pilot’s failure to see and avoid a transmission wire during takeoff.NTSB WPR21LA080Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Palm Springs, CAThe student pilot’s failure to maintain aircraft control during an attempted go-around, which resulted in an exceedance of the airplane’s critical angle of attack, aerodynamic stall, and subsequent impact with terrain.NTSB ANC21LA008Accident · No injuriesClass 4 · LimitedFinal reportPiper PA18 · Juneau, AKThe solo student pilot’s failure to maintain directional control during taxi in strong crosswind conditions, which resulted in a loss of control and subsequent impact with a ditch.NTSB CEN21LA071Accident · No injuriesClass 3 · LimitedFinal reportCessna 551 · Lufkin, TXThe pilot’s decision to land on a runway that did not provide enough length to stop the airplane given the wet surface conditions, resulting in a runway excursion.NTSB CEN21LA079Accident · No injuriesClass 4 · LimitedFinal reportHutson Star-Lite · San Antonio, TXThe pilot’s decision to land on a soft terrain which resulted in the failure of the nose landing gear.NTSB CEN21LA070Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA38 · Franklin, ARThe impairment of both pilots from carbon monoxide exposure due to a degraded muffler. Contributing to the accident was the inadequate maintenance inspection, which failed to detect the degraded muffler.NTSB WPR21LA155Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International RX 8 · St. George, UTThe pilot’s failure to maintain control of the balloon and a member of the ground crews entanglement with a tether rope, which resulted in a serious injury when they fell to the ground after the balloon unexpectedly ascended.NTSB ERA21LA061Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Bellefonte, PAThe pilot's failure to maintain directional control while landing, which resulted in a runway excursion.NTSB ERA21LA060Accident · No injuriesClass 4 · LimitedFinal reportChampion 7EC · Northhampton, NYThe pilot’s loss of airplane control during an off-airport landing on soft sand, which resulted in a nose over.NTSB ERA21LA058Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Georgetown, DEThe pilot’s failure to maintain airplane control while on landing in gusting crosswind conditions.NTSB CEN21LA069Accident · Minor injuriesClass 4 · LimitedFinal reportGlobe GC1A · Ottawa, KSThe student pilot’s failure to maintain attain proper pitch attitude of the airplane causing it to exceed its critical angle of attack, enter an aerodynamic stall, and subsequently impact terrain, and his poor decision making and lack of experience that led…NTSB CEN21LA068Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · French Lick, INThe pilot’s improper in-flight decision making which resulted in a total loss of engine power due to fuel starvation.NTSB CEN21LA111Accident · No injuriesClass 4 · LimitedFinal reportCessna T182T · Hollister, MOThe pilot’s failure to maintain proper airspeed control during an instrument approach in instrument meteorological conditions, which led to a bounced landing, collapsing the nose landing gear, and resulting in substantial damage.NTSB CEN21LA067Accident · 2 fatalClass 3 · LimitedFinal reportVans RV4 · Telluride, COThe pilot’s failure to maintain adequate airspeed during the turn from the base leg to final approach, which resulted in the airplane exceeding its critical angle of attack and entering an inadvertent aerodynamic stall/spin at a low altitude over mountainous…NTSB ERA21LA056Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Atlanta, GAThe Cessna pilot’s failure to tune his radio to the common traffic advisory frequency, which resulted in a lack of awareness of the other aircraft operating at the airport. Contributing to the accident was the Cessna pilot’s lack of understanding of the…NTSB ERA21LA055Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Manville, NJThe pilot’s failure to maintain a proper glidepath while on approach to the runway, and the flight instructor’s delayed remedial action, which resulted in the airplane colliding with a tree on final approach.NTSB ERA21LA054Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32 · Greenville, SCA partial loss of engine power due to the pilot’s delayed application of carburetor heat, which resulted in carburetor icing.NTSB ERA21LA053Accident · 1 fatalClass 3 · LimitedFinal reportBeech V35 · Deltaville, VAAn uncontrolled descent and impact with terrain following an in-flight collision with seagulls.NTSB ERA21LA052Accident · 1 fatalClass 3 · LimitedFinal reportLancair Legacy FG · Hollywood, FLThe pilot/owner’s failure to properly reinstall the number 1 cylinder spark plug, which resulted in a partial loss of engine power during the initial climb. Contributing was the pilot's exceedance of the airplane’s critical angle of attack during an attempted…NTSB CEN21LA087Accident · No injuriesClass 4 · LimitedFinal reportPiper PA12 · Gilliam, LAThe non-instrument rated pilot’s encounter with poor weather conditions resulting in his performing a precautionary landing to a cornfield and subsequently nosing over.NTSB ERA21LA051Accident · Serious injuriesClass 4 · LimitedFinal reportJ&J Ultralights Sea-Wing · Placida, FLThe pilot/owner’s improper preflight inspection of the weight-shift trike, which resulted in a loss of control at takeoff due to an improperly adjusted wingtip.NTSB WPR21LA059Accident · No injuriesClass 3 · LimitedFinal reportCessna TU206 · Twentynine Palms, CAThe pilot’s decision to takeoff with a known mechanical engine anomaly, and the failure of the No. 2-cylinder exhaust valve, which resulted in a total loss of engine power during the initial climb and subsequent impact with terrain.NTSB WPR21FA057Accident · 1 fatalClass 3 · FieldFinal reportBlevins Kamron Odyssey · Arlington, WAThe pilot’s loss of airplane control for reasons that could be determined based on available evidence.NTSB ERA21LA049Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Lititz, PAThe pilot’s inadvertent attempt to takeoff on a taxiway, rather than a runway, which resulted in a collision with a fence during takeoff.NTSB CEN21LA066Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Lawrence, KSThe student pilot’s improper landing flare/touchdown which resulted in a hard landing.NTSB ERA21LA050Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Cynthiana, KYThe pilot’s failure to maintain proper glide path during a visual approach that was conducted at night, resulting in a collision with trees and terrain.NTSB CEN21LA064Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · El Paso, TXThe pilot’s loss of control on takeoff during a touch and go landing, which resulted in a runway excursion.NTSB ERA21LA046Accident · No injuriesClass 4 · LimitedFinal reportRobinson R44 · Austell, GAThe flight instructor’s failure to maintain adequate clearance above the gravel surface in a hover, which resulted in a dynamic rollover.NTSB ERA21LA045Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Manville, NJThe pilot's failure to maintain directional control while landing in a gusty crosswind, which resulted in a runway excursion and noseover.NTSB WPR21LA071Accident · Minor injuriesClass 3 · LimitedFinal reportCo Z Cozy · Compton, CAThe partial loss of engine power due to an improperly installed sparkplug.NTSB CEN21LA062Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Johnson City, KSThe pilot’s improper decision to fly the airplane at too low an altitude resulting in the airplane impacting terrain.NTSB ERA21LA042Accident · Serious injuriesClass 3 · LimitedFinal reportRepublic RC3 · Advance, NCThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ANC21LA007Accident · 2 fatalClass 3 · LimitedFinal reportCessna 150L · Colton, ORThe pilot’s failure to maintain positive control of the airplane in mountainous terrain during dark night conditions as a result of spatial disorientation which led to a loss of control and subsequent impact with terrain.NTSB WPR21LA058Accident · Minor injuriesClass 3 · LimitedFinal reportAir Creation Tanarg · Pahrump, NVThe pilot’s failure to maintain control while maneuvering at low altitude.NTSB CEN21LA074Accident · No injuriesClass 4 · LimitedFinal reportZlin Savage Cub-S · Francis, OKThe pilot’s selection of unsuitable terrain for the landing, which resulted in a nose over when the airplane encountered soft sand during the landing roll.NTSB WPR21LA056Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Howe, IDThe pilot’s failure to maintain clearance from mountainous terrain after an encounter with a downdraft, which resulted in a collision with terrain.NTSB WPR21LA055Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 152 · San Bernardino, CAA total loss of engine power due to fuel contamination. Contributing to the accident was an inadequate preflight inspection.NTSB ERA21LA048Accident · No injuriesClass 4 · LimitedFinal reportVans RV4 · Milton, FLThe pilot's failure to maintain directional control during a crosswind landing.NTSB ERA21LA043Accident · No injuriesClass 4 · LimitedFinal reportAerospatiale AS355 · Hammonton, NJThe pilot's decision to continue the takeoff with a perceived mechanical deficiency.NTSB DCA21LA024Accident · Serious injuriesClass 4 · LimitedFinal reportBombardier CL600 2C10 · Phoenix, AZThe flight attendant’s use of improper procedures when opening the main cabin door.NTSB WPR21LA054AccidentClass 4 · LimitedFinal reportGeneral Atomics MQ-9 · Sierra Vista, AZThe pilot’s incorrect automated landing profile selection, which resulted in an impact with a runway trench. Contributing to the accident was the pilot receiving instruction's and instructor's failure to spot the incorrect landing profile selection during…NTSB WPR21LA053Accident · No injuriesClass 4 · LimitedFinal reportAir Creation Buggy · Benson, AZThe non-rated pilot’s unstable approach and failure to maintain aircraft control, which resulted in a hard landing and collision with terrain.NTSB WPR21LA051Accident · Minor injuriesClass 4 · LimitedFinal reportMaule MX7 · Moab, UTThe pilot's failure to maintain airplane control during takeoff from an unimproved airstrip, which resulted in a nose-over.NTSB WPR21FA048Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Los Angeles, CAMaintenance personnel’s failure to properly secure the throttle control hardware during recent maintenance, which resulted in its disconnection and a subsequent loss of engine power on approach for landing.NTSB CEN21LA060Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Salem, INThe pilot’s failure to avoid an obstacle during his approach to land.NTSB CEN21LA055Accident · 2 fatalClass 3 · LimitedFinal reportCessna 182R · Rockwall, TXThe pilot’s decision to continue an unstabilized approach and his delayed go-around decision, which resulted in the airplane’s impact with power lines and the ground. Contributing to the accident was the inaccurate wind direction reporting as a result of a…