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 ERA14LA142Accident · No injuriesLimited investigationFinal reportCessna 172R · Jackson, TNA total loss of engine power due to maintenance personnel’s improper installation of the lower vacuum pump.NTSB DCA14CA090Accident · Serious injuriesData collectionFinal reportBoeing 737 - 932ER · San Diego, CAthe flight attendant's inadvertent trip and fall over a passenger bag that was in the aisle.NTSB WPR14FA127Accident · 1 fatalField investigationFinal reportPiper PA 46 350P · Truckee, CAThe pilot’s failure to properly execute the missed approach in instrument conditions. Contributing to the accident were the pilot’s lack of instrument proficiency, as demonstrated by his failure to execute the required procedure turn to align with the final…NTSB ANC14CA017Accident · Minor injuriesData collectionFinal reportSilvaire Luscombe 8E · Alegnagik, AKThe pilot's failure to determine that the ice that he was taxiing on was safe for operation.NTSB ERA14FA138Accident · 1 fatalField investigationFinal reportBeech F33 · Lumberport, WVA stroke or cardiovascular event, which resulted in the pilot’s acute impairment or incapacitation and his subsequent flight into terrain.NTSB ERA14CA140Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Mayaguez, PRThe pilot's loss of directional control of the airplane during landing, which resulted in a runway excursion.NTSB ERA14CA139Accident · No injuriesData collectionFinal reportPiper PA 11S · Marlboro, MAThe pilot's loss of directional control during the landing rollout in crosswinds, resulting in a runway excursion and subsequent impact with a snow bank.NTSB CEN14CA157Accident · No injuriesData collectionFinal reportAeronca 7AC · Adrian, TXThe pilot's failure to maintain directional control of the airplane during the landing roll which resulted in the airplane ground looping.NTSB WPR14CA129Accident · No injuriesData collectionFinal reportPartenavia P 68 Observer · Molokai, HIThe pilot's inadequate decision to continue an unstable approach in dark night conditions, which resulted in a collision with trees and hard landing.NTSB CEN14CA177Accident · No injuriesData collectionFinal reportCessna A185F · Fredericksburg, TXThe pilot did not maintain directional control of the airplane during the takeoff with a gusting crosswind.NTSB WPR14FA124Accident · 3 fatalField investigationFinal reportPiper PA31 · Lanai City, HIThe pilot’s spatial disorientation while turning during flight in dark night conditions and terrain-induced turbulence, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s impairment from a sedating antihistamine.NTSB WPR14CA122Accident · No injuriesData collectionFinal reportCessna 172M · Ramona, CAThe student pilot's inadequate flare and failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB ERA14CA134Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Gulf Shores, ALThe student pilot's incorrect rudder input, which resulted in a ground loop and collision with a runway sign.NTSB CEN14CA151Accident · No injuriesData collectionFinal reportBellanca 17 30A · Santa Rosa, NMThe pilot's mismanagement of the available fuel supply which resulted in a loss of engine power and subsequent emergency landing.NTSB WPR14LA119Accident · 1 fatalLimited investigationFinal reportSabrena Dragonfly · Maricopa, AZThe pilot’s failure to maintain control of the airplane while maneuvering, which resulted in the airplane exceeding its critical angle of attack and subsequently experiencing an aerodynamic stall and spin at a low altitude.NTSB ERA14CA136Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Lake Wales, FLThe pilot's improper flare during a water landing, which resulted in the wings contacting the water.NTSB CEN14LA149Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Presidio, TXThe pilot’s failure to maintain sufficient rotor rpm when transitioning the helicopter from a hover to forward flight, which resulted in a loss of helicopter control.NTSB WPR14LA118Accident · No injuriesLimited investigationFinal reportCessna P210N · Bountiful, UTFuel starvation due to the in-flight loosening of the fuel lines attached to the fuel flow indicator as a result of inadequate maintenance.NTSB ERA14LA149Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Alabaster, ALThe pilot’s delay in aborting the takeoff following the loss of directional control early in the takeoff roll due to a deflated left main landing gear tire.NTSB CEN14LA148Accident · 1 fatalLimited investigationFinal reportVans RV-9A · Tribune, KSThe pilot’s failure to maintain airplane control while conducting high-g turns, which resulted in impact with terrain. Contributing to the accident was the pilot’s improper decision to initiate the flight with a severe progressive neurological disorder that…NTSB WPR14LA117Accident · Serious injuriesLimited investigationFinal reportBeech A45 · Hollister, CAThe total loss of engine power during initial climb due to fuel starvation and the pilot’s inadequate preflight inspection and improper fuel management.NTSB WPR14CA120Accident · No injuriesData collectionFinal reportPiper PA 16 · Scappoose, ORThe pilot's failure to maintain directional control during landing roll. Contributing to the accident was the pilot's diverted attention and inadequate preflight inspection.NTSB ERA14FA128Accident · 3 fatalField investigationFinal reportBeech 95-B55 · LaGrange, GAThe pilot's overreaction to a perceived conflict with a tow plane and glider on an intersecting runway, which resulted in a loss of control during an attempted aborted landing. Contributing to the accident was the failure of the glider tow operator to follow…NTSB ERA14LA137Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Macon, GAThe pilot’s failure to maintain airplane control while maneuvering in the traffic pattern at low altitude in gusting wind. Contributing to the accident was the pilot’s improper decision to maneuver in the traffic pattern at a low altitude that did not allow…NTSB CEN14LA147Accident · No injuriesLimited investigationFinal reportAir Tractor AT 602 · Church Point, LAThe pilot’s improper preflight inspection and in-flight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN14FA145Accident · 1 fatalField investigationFinal reportBeech B100 · Pearland, TXThe noninstrument-rated pilot's loss of airplane control during a missed instrument approach. Contributing to the accident was the pilot's decision to file an instrument flight rules flight plan and to fly into known instrument meteorological conditions.NTSB WPR14CA115Accident · No injuriesData collectionFinal reportBell 47G 5A · Greenfield, CAThe pilot's failure to maintain clearance from a power pole during low-altitude maneuvering flight.NTSB ERA14CA126Accident · Serious injuriesData collectionFinal reportSchempp-Hirth Ventus 2B · Burnsville, NCThe pilot's improper use of the spoilers, which resulted in an uncontrolled descent and subsequent impact with trees.NTSB CEN14FA143Accident · 1 fatalField investigationFinal reportHawker SEA Fury ISS 25 · Breckenridge, TXThe pilot’s inadequate emergency response to a runaway propeller and his failure to maintain airspeed, which resulted in the airplane exceeding its critical angle-of-attack and stalling. The cause of the runaway propeller was undetermined.NTSB ERA14FA123Accident · 1 fatalField investigationFinal reportWilliams Christopher T Sonex · Wellington, FLThe pilot's failure to maintain adequate airspeed following a partial loss of engine power during initial climb, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the…NTSB ERA14CA127Accident · Minor injuriesData collectionFinal reportCessna 172S · Caldwell, NJThe pilot's failure to maintain directional control while landing.NTSB ERA14LA133Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Allentown, PAThe flight instructor’s failure to maintain directional control during the landing.NTSB CEN14FA141Accident · 3 fatalField investigationFinal reportBeech 35/33 · Telluride, COThe airplane’s failure to obtain a positive climb rate, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s inadequate preflight planning.NTSB CEN14FA140Accident · 1 fatalField investigationFinal reportHillam Scott L Rans S 10 · Shepherd, TXThe noncertificated pilot’s improper decision to attempt aerobatic maneuvers that exceeded the airplane’s design limitations, which resulted in the subsequent in-flight breakup of the airplane. Contributing to the accident was the pilot’s lack of aerobatic…NTSB WPR14CA116Accident · No injuriesData collectionFinal reportCessna 172 - N · Glendale, AZThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a runway excursion and subsequent impact with a taxiway sign.NTSB ERA14FA120Accident · 2 fatalField investigationFinal reportCessna 210L · Clay, ALThe pilot's failure to maintain control of the airplane while being vectored to intercept the localizer during night instrument meteorological conditions (IMC). Contributing to the accident was the operator's inadequate dispatch procedures, which did not…NTSB ERA14CA124Accident · No injuriesData collectionFinal reportCessna 172S · Mansfield, MAThe student pilot's failure to maintain an adequate approach glide path, which resulted in a collision with a snow bank.NTSB CEN14LA146Accident · No injuriesLimited investigationFinal reportFogg Quicksilver MX II · Holland, MIThe pilot's inability to maintain airplane control after inadvertently landing in an area of deep snow on a frozen lake.NTSB ERA14LA122Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Pinson, TNThe noninstrument-rated pilot’s decision to continue flight into deteriorating weather conditions at night and his failure to divert in a timely manner, which resulted in an off-airport precautionary landing and subsequent substantial damage to the airplane.NTSB CEN14IA139Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Gunnison, COThe pilot's improper decision to initiate the flight into an area with forecast icing conditions, which resulted in an encounter with in-flight icing conditions that prevented the airplane from being able to maintain altitude.NTSB CEN14CA142Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Bonham, TXThe pilot's inadequate recovery from a loss of tail rotor effectiveness during a low altitude downwind hover in a gusty wind condition resulting in the helicopter contacting the ground and rolling over.NTSB CEN14CA152Accident · No injuriesData collectionFinal reportCessna 172R · Ellsworth, KSthe student pilot's failure to maintain directional control during landing.NTSB CEN14CA137Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Gordon, NEA loss of engine power due to the pilot's improper planning and miscalculation of the fuel supply, which resulted in fuel exhaustion.NTSB ERA14CA119Accident · No injuriesData collectionFinal reportPiper PA 38-112 · West Milford, NJThe failure of the pilot-in-command to maintain directional control during landing.NTSB CEN14LA138Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Marion, IAThe pilot’s failure to attain a touchdown on the runway’s hard surface, which resulted in a loss of directional control.NTSB CEN14CA182Accident · No injuriesData collectionFinal reportCessna 182J · Belen, NMThe pilot's failure to ensure adequate fuel onboard for the intended flight.NTSB ERA14CA143Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Orlando, FLThe pilot's inadequate preflight inspection in which he failed to remove the tail rotor covers, which resulted in the failure of the tail rotor drive shaft during engine start.NTSB ERA14FA115Accident · 2 fatalField investigationFinal reportRobinson Helicopter R44 II · Panacea, FLThe pilot’s failure to maintain adequate clearance from trees during a takeoff at night. Contributing to the accident was the pilot’s lack of recent night flight experience.NTSB ERA14CA118Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Sussex, NJThe pilot's improper preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN14LA133Accident · No injuriesLimited investigationFinal reportCessna 182A · Lexington, TXThe pilot’s improper use of the carburetor heat, which resulted in a total loss of engine power due to carburetor icing.