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 CEN14GA109Accident · Serious injuriesFinal reportAmerican Eurocopter AS350B3 · Encino, TXThe pilot’s failure to maintain directional control while maneuvering, which resulted in a loss of tail rotor effectiveness. Contributing to the accident were the pilot’s limited experience in the operating environment and lack of formal mission training.NTSB WPR14FA091Accident · Minor injuriesField investigationFinal reportCirrus Design SR22 · Pocatello, IDThe distributor gear teeth failure of the right magneto that resulted in severe engine vibration and partial loss of engine power, which progressively led to the failure of the left magneto distributor drive gear teeth. Contributing to the airplane’s…NTSB CEN14CA108Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Beaumont, TXThe student pilot not controlling the helicopter following a wind gust and the flight instructor's inadequate remedial action resulting in the helicopter rolling over on its side during a landing.NTSB CEN14CA106Accident · Minor injuriesData collectionFinal reportCessna P210N · Pagosa Springs, COThe pilot's inadequate preflight inspection which led to a loss of oil pressure and partial loss of engine power on takeoff. Contributing to the accident was the pilot's failure to check the security of the oil filler cap prior to the flight.NTSB CEN14FA102Accident · 2 fatalField investigationFinal reportMooney M20R · Boyne City, MIThe pilot’s failure to maintain control of the airplane as he attempted to return to the airport after encountering dark night conditions and heavy snow showers.NTSB CEN14LA103Accident · No injuriesLimited investigationFinal reportBell 430 · West Delta 109The pilot’s failure to maintain tail rotor clearance from a handrail on a crane davit on an oil platform during landing.NTSB CEN14FA099Accident · 1 fatalField investigationFinal reportCanadair CL 600 2B16 · Aspen, COThe flight crew's failure to maintain airplane control during landing following an unstabilized approach. Contributing to the accident were the flight crew's decision to land with a tailwind above the airplane's operating limitations and their failure not to…NTSB CEN14CA104Accident · No injuriesData collectionFinal reportCessna 172P · Cotulla, TXThe student pilot did not maintain control of the airplane while landing. The flight instructor's failure to monitor the flight contributed to the accident.NTSB WPR14CA090Accident · No injuriesData collectionFinal reportCessna 140 · Marana, AZThe pilot did not maintain directional control during the landing roll out when the right brake did not release completely after he applied, then released brake pressure, which resulted in a ground loop. Contributing to the accident was the taxi speed.NTSB WPR14CA088Accident · No injuriesData collectionFinal reportClayhold Sportsman GS-2 · Manzanita, ORThe pilot's inadequate landing flare and failure to maintain control of the airplane while landing with gusting wind.NTSB WPR14CA086Accident · Minor injuriesData collectionFinal reportDehavilland Beaver DHC 2 MK.1 · Shaw Island, WAThe pilot's failure to maintain directional control during takeoff in variable wind conditions, resulting in a collision with trees lining the left side of the runway.NTSB ERA14LA089Accident · No injuriesLimited investigationFinal reportFK Lightplanes FK9 ELA SW · Canton, GAA partial loss of engine power during cruise flight due to an overly lean fuel-air mixture, which resulted from an incorrectly installed float chamber vent line and led to a subsequent off-airport landing.NTSB ERA14LA086Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Buckhannon, WVThe pilot’s improper in-flight fuel mixture management and failure to use the appropriate checklist or manuals during approach to landing, which resulted in a loss of engine power.NTSB DCA14CA034Accident · No injuriesData collectionFinal reportBoeing 737 · Las Vegas, NVthe captain's over rotation during the bounced landing.NTSB CEN14LA112Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Forsyth, MOThe pilot's improper flight planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ANC14CA014Accident · Minor injuriesData collectionFinal reportCessna 170 - B · Nome, AKThe pilot's failure to adequately remove water-contaminated fuel during the preflight inspection, which resulted in a total loss of engine power.NTSB CEN14CA098Accident · No injuriesData collectionFinal reportBell 206B · Temple, TXThe pilot's loss of control while landing on a mobile helipad.NTSB WPR14LA084Accident · No injuriesLimited investigationFinal reportEurocopter EC 130 B4 · Boulder City, NVA loss of engine power due to fuel starvation as a result of the noncertificated maintenance technician’s failure to properly tighten and safety wire a B-nut fitting. Contributing to the accident was the maintenance technician’s failure to follow the…NTSB ERA14LA084Accident · 1 fatalLimited investigationFinal reportBeech A36 · Fryeburg, METhe pilot’s incapacitation due to a cardiac event during taxi.NTSB ERA14LA083Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Alabaster, ALThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR14CA083Accident · No injuriesData collectionFinal reportCessna 195A · Salinas, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB CEN14CA096Accident · Minor injuriesData collectionFinal reportCessna 172K · Concordia, KSThe pilot's failure to maintain a proper glidepath during approach which resulted in the airplane landing long, and his decision to turn off of the runway during the landing roll which resulted in a collision with an earth berm.NTSB WPR14LA080Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Pacoima, CAThe flight instructor’s inadequate compensation for the gusting crosswind conditions during landing, which resulted in a loss of airplane control.NTSB WPR14CA082Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Roberts, MTThe pilot's selection of unsuitable terrain during taxi, which resulted in a loss of directional control.NTSB ERA14CA080Accident · Minor injuriesData collectionFinal reportSchweizer 269C · White Plains, NYThe flight instructor's failure to maintain airspeed during a practice autorotation, which resulted in a hard landing and subsequent loss of controlNTSB WPR14FA078Accident · 2 fatalField investigationFinal reportCessna 172K · Fresno, CAThe pilot’s failure to maintain adequate clearance from trees while on approach, which subsequently led to a loss of airplane control. Also causal was the pilot’s continued operation of the airplane at night with a diagnosed medical condition that degraded…NTSB ERA14CA082Accident · No injuriesData collectionFinal reportCessna 182H · Littleton, NCThe pilot's failure to maintain directional control during takeoff.NTSB ERA14FA077Accident · 2 fatalField investigationFinal reportPiper PA-30 · Biglerville, PAThe noninstrument-rated pilot's spatial disorientation after inadvertently encountering instrument meteorological conditions at night and his subsequent loss of airplane control.NTSB WPR14CA077Accident · Minor injuriesData collectionFinal reportCessna T182T · Hillsboro, ORThe pilot's decision to continue the instrument approach beyond the published missed approach point.NTSB WPR14CA076Accident · No injuriesData collectionFinal reportAviat A-1C-200 · Laural, MTThe pilot's failure to maintain directional control during takeoff with a gusting crosswind, which resulted in the collision with terrain. Contributing to the accident was the pilot's distraction when the door popped open.NTSB WPR14CA075Accident · Serious injuriesData collectionFinal reportCessna 152 · St. Ignatius, MTThe non-certificated pilot's failure to maintain a stabilized approach for landing that resulted in a long landing and subsequent runway overrun.NTSB ERA14CA078Accident · No injuriesData collectionFinal reportCessna 172S · Miami, FLThe pilot's improper flare during a gusty, crosswind landing.NTSB ANC14CA013Accident · No injuriesData collectionFinal reportPiper PA 20 · Platinum, AKThe pilot's failure to maintain directional control during a crosswind landing.NTSB WPR14CA074Accident · No injuriesData collectionFinal reportCessna 172M · Fullerton, CAThe pilot's inadequate landing flare, which resulted in a bounced landing.NTSB WPR14CA073Accident · No injuriesData collectionFinal reportCessna A185F · Carson City, NVThe pilot's failure to maintain directional control during landing which resulted in the airplane veering off the runway and nosing over.NTSB WPR14LA071Accident · No injuriesLimited investigationFinal reportPiper PA 32-301 · Los Angeles, CAThe total loss of engine power during takeoff due to fuel starvation, which resulted from the pilot’s failure to adequately manage the fuel supply.NTSB ERA14FA075Accident · 1 fatalField investigationFinal reportBeech A36TC · Chatlottesville, VAThe pilot’s failure to position the fuel selector handle in a fuel tank detent, which resulted in a total loss of engine power due to fuel starvation. Contributing to the pilot’s fatal injuries was the separation of his shoulder harness due to overload in an…NTSB ERA14FA074Accident · 1 fatalField investigationFinal reportRaytheon G36 · Panama City, FLThe pilot’s inadequate preflight and inflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the pilot’s injuries was his failure to use the available shoulder harness.NTSB ERA14FA073Accident · 2 fatalField investigationFinal reportRaytheon 390 · Atlanta, GAThe pilot's failure to maintain airplane control while maneuvering the airplane in the traffic pattern at night. Contributing to the accident was the pilot's impairment from the use of illicit drugs.NTSB CEN14LA091Accident · Serious injuriesLimited investigationFinal reportQuicksilver Unknown · Palestine, TXThe noncertificated pilot’s failure to maintain airspeed, which resulted in an inadvertent stall during landing.NTSB CEN14LA089Accident · Minor injuriesLimited investigationFinal reportCessna 305C (0 1E) · Hondo, TXThe pilot's loss of directional control during an attempted go-around for reasons that could not be determined based on the available evidence. Contributing to the accident was the flight instructor’s and pilot’s decision to continue flight after experiencing…NTSB CEN14LA087Accident · Serious injuriesLimited investigationFinal reportMaarten H Versteeg Zenith 601XL(B) · Leakey, TXThe pilot’s failure to maintain control of the airplane after the canopy opened on takeoff. Contributing to the accident was the pilot’s failure to properly secure the canopy latch before takeoff.NTSB WPR14CA070Accident · No injuriesData collectionFinal reportBellanca 7ECA · San Jose, CAThe flight instructor's failure to correct for the student pilot's loss of aircraft control in a timely manner during takeoff. Contributing to the accident was the instructor's inability to see the taxiway sign from the rear seat.NTSB ANC14LA011Accident · No injuriesLimited investigationFinal reportCessna 172M · Bethel, AKThe pilot’s decision to abort the takeoff with insufficient runway remaining, which resulted in a runway excursion.NTSB WPR14CA069Accident · Minor injuriesData collectionFinal reportCessna 150F · Henderson, NVThe flight crew's improper in-flight fuel planning lead to fuel exhaustion, which resulted in a complete loss of engine power.NTSB ERA14CA081Accident · No injuriesData collectionFinal reportCessna 172N · Farmingdale, NJThe student pilot's improper landing flare, which resulted in a hard landing.NTSB WPR14FA068Accident · 1 fatalField investigationFinal reportCessna 208B · Kalaupapa, HIThe loss of engine power due to the fracture of multiple blades on the compressor turbine wheel, which resulted in a ditching. The reason for the blade failures could not be determined due to secondary thermal damage to the blades.NTSB CEN14FA084Accident · 3 fatalField investigationFinal reportPiper PA 24-250 · Collbran, COThe pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in an aerodynamic stall/spin and subsequent impact with terrain.NTSB CEN14LA086Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Oscoda, MIThe student pilot’s loss of control during landing in gusting wind conditions. Contributing to the accident was the pilot’s decision to land with gusting wind.NTSB CEN14LA081Accident · No injuriesLimited investigationFinal reportRockwell International 112 · Hammond, LAThe total loss of engine power due to oil starvation because of a fractured governor oil line, which resulted from the improper installation of the governor oil line assembly during the last oil line replacement.