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 GAA18CA256Accident · No injuriesData collectionFinal reportCessna A185 · Chandler, AZThe pilot’s failure to maintain directional control during landing in gusting tailwind conditions.NTSB GAA18CA255Accident · No injuriesData collectionFinal reportPphu Ekolot KR-030 Topaz · Dekalb, ILThe pilot’s improper landing flare during gusting wind conditions, and the flight instructor’s delayed remedial action.NTSB GAA18CA254Accident · No injuriesData collectionFinal reportBeech 58 · Sisters, ORThe pilot’s failure to maintain sufficient altitude during approach in gusting crosswind conditions, which resulted in an attempted rejected landing and a runway undershoot.NTSB ERA18FA141Accident · 1 fatalField investigationFinal reportAeronca 7AC · Middletown, NYThe pilot's exceedance of the airplane's critical angle of attack during climbout, which resulted in an aerodynamic stall from which the pilot could not recover.NTSB CEN18LA159Accident · No injuriesLimited investigationFinal reportBeech A36 · Shullsburg, WIA catastrophic engine failure due to improper torque on the engine through-bolt nuts, which resulted in relative movement between the crankcase halves, damage to a main journal bearing, and a loss of oil lubrication.NTSB CEN18FA160Accident · 2 fatalField investigationFinal reportBelair Raven · Sault Ste Marie, MIThe pilot's failure to maintain adequate airspeed during takeoff in gusty crosswind conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.NTSB WPR18LA135Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 152 · Tamiami, FLThe non-instrument-rated pilot’s loss of control during an encounter with instrument meteorological conditions at night. Contributing to the accident was the pilot's decision to depart on the flight without obtaining approval to fly at night in accordance…NTSB GAA18CA265Accident · No injuriesData collectionFinal reportAir Tractor AT 802 · Truman, ARThe pilot’s failure to see and avoid a pole during an agricultural application flight.NTSB GAA18CA253Accident · No injuriesData collectionFinal reportCessna 172 · Glendale, AZThe student pilot’s failure to maintain runway alignment during takeoff, which resulted in an aborted takeoff and runway excursion.NTSB GAA18CA258Accident · No injuriesData collectionFinal reportBerger Bernard M Pulsar Series III · Palmyra, PAThe pilot’s failure to maintain an appropriate approach speed, which resulted in a bounced landing and a runway overrun.NTSB WPR18FA131Accident · 1 fatalField investigationFinal reportAmerican Air Racing Thunder Mustang · Reno, NVThe pilot's failure to properly secure the engine coolant pump pulley during recent maintenance, which resulted in a loss of the engine's lubrication, cooling, and propeller control systems, and a forced landing, during which the airplane nosed over.…NTSB GAA18CA347Accident · No injuriesData collectionFinal reportPiper PA28 · Pine Spring, TXThe pilot’s failure to maintain adequate altitude while flying over mountainous terrain in turbulent wind conditions at night, which resulted in a tree strike.NTSB GAA18CA250Accident · Minor injuriesData collectionFinal reportMichael R Alexander Mosquito XE · Iron Station, NCThe noncertificated pilot’s decision to practice hovering the helicopter in a confined space, which resulted in the tail rotor striking a tree.NTSB GAA18CA248Accident · Minor injuriesData collectionFinal reportCessna 172 · Port Angeles, WAThe pilot’s exceedance of the airplane’s critical angle of attack during a turn away from terrain, which resulted in an accelerated stall. Contributing to the accident was the pilot’s decision to delay the turn to avoid terrain.NTSB ERA18LA140Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Panama City, FLThe pilot's failure to properly remove and secure the tie-down ropes during the preflight inspection, which resulted in the ropes becoming entangled in the rotor head swashplate and pitch control rods during flight and the subsequent loss of pitch control.NTSB ERA18FA138Accident · 1 fatalField investigationFinal reportPiper PA32 · West Milford, NJAn in-flight fire and total loss of engine power after takeoff due to a loose fuel line. Contributing to the accident was the installation of an unapproved fuel line by unknown personnel.NTSB CEN18LA157Accident · Minor injuriesLimited investigationFinal reportHartline J Bon Hartline Kitfox III · Marathon, TXThe failure of the flaperon hinge attachment point during takeoff, which resulted in a loss of airplane control. Contributing to the accident was the lack of reinforcement of the hinge attachment point in accordance with the manufacturer’s service bulletin.NTSB CEN18LA156Accident · No injuriesLimited investigationFinal reportLaminar Lancair 360 · Woodward, OKThe pilot-rated passenger’s inadvertent contact with and closure of the emergency fuel shutoff valve, which resulted in the total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's lack of experience in the accident…NTSB WPR18LA132Accident · Minor injuriesLimited investigationFinal reportCosmos Phase III · Fernandina Beach, FLThe student pilot's failure to maintain aircraft control and the flight instructor’s failure to adequately monitor the student pilot before aircraft control was lost at a low altitude.NTSB DCA18CA165Accident · No injuriesData collectionFinal reportBombardier CL600 2D24 · Queens, NYthe failure of the captain of Delta 212 to ensure adequate clearance while taxiing behind Endeavor 3413.NTSB GAA18CA294Accident · No injuriesData collectionFinal reportCessna 172 · Palo Alto, CAThe pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA18CA252Accident · No injuriesData collectionFinal reportBeech 95B55 · Little Rock, ARThe pilot’s improper landing flare.NTSB GAA18CA243Accident · No injuriesData collectionFinal reportCessna 310 · Gainesville, FLThe pilot’s failure to maintain an adequate approach path at night, which resulted in a tree strike.NTSB GAA18CA249Accident · No injuriesData collectionFinal reportHughes 369 · Newark, OHThe pilot’s failure to maintain adequate clearance from transmission power wires, which resulted in a tail rotor strike.NTSB GAA18CA246Accident · No injuriesData collectionFinal reportCessna 182 · Page, AZThe pilot’s failure to maintain directional control during a rejected takeoff in gusting quarting tailwind conditions.NTSB GAA18CA242Accident · No injuriesData collectionFinal reportSeno Louis C SR KIS · Eagle Lake, TXThe pilot’s failure to maintain directional control during takeoff in gusting crosswind conditions.NTSB GAA18CA244Accident · No injuriesData collectionFinal reportLuscombe 8 · Eunice, LAThe pilot’s failure to maintain clearance from a tree while on approach to land.NTSB GAA18CA241Accident · No injuriesData collectionFinal reportAeronca 65 LB · Carrington, NDThe pilot’s failure to maintain directional control and his subsequent excessive brake application during landing, which resulted in a nose-over.NTSB GAA18CA238Accident · No injuriesData collectionFinal reportStinson 108 · Spokane, WAThe pilot’s failure to maintain directional control during landing.NTSB ERA18FA137Accident · 1 fatalField investigationFinal reportPiper PA28R · Gainesville, GAA partial loss of engine power due to inadequate thru-bolt and stud preload tension by undetermined maintenance personnel, which resulted in fretting between the engine crankcase halves, and the subsequent separation of the No. 2 cylinder due to the fatigue…NTSB GAA18CA239Accident · No injuriesData collectionFinal reportBeech 76 · Vacaville, CAThe pilot under instruction’s failure to extend the landing gear and the flight instructor’s inadequate supervision and failure to ensure that the landing gear was extended.NTSB GAA18CA237Accident · Minor injuriesData collectionFinal reportStinson 108 · Eliza Island, WAThe pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB GAA18CA236Accident · No injuriesData collectionFinal reportL-Bird CCX-2000 · Hood River, ORThe pilot’s decision to take off in gusting wind conditions, which resulted in a loss of directional control.NTSB CEN18LA150Accident · 2 fatalLimited investigationFinal reportWolfe Kitfox V · Kalkaska, MIThe pilot's failure to maintain airplane control that resulted in a stall/spin following climb from the departure airport.NTSB CEN18FA149Accident · 3 fatalField investigationFinal reportEurocopter AS 350 B2 · Hazelhurst, WIThe pilot's loss of helicopter control as a result of fatigue during cruise flight at night.NTSB WPR18LA127Accident · Serious injuriesLimited investigationFinal reportYakovlev YAK 52 · Hillsboro, ORA partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or failures that would have precluded normal operation. Contributing to the accident was…NTSB ERA18LA136Accident · No injuriesLimited investigationFinal reportCessna 402 · Barre Plains, MAThe pilot's improper decision to land with a tailwind, which resulted in a touchdown with insufficient runway remaining to stop the airplane.NTSB GAA18CA234Accident · No injuriesData collectionFinal reportPiper PA28 · Wickenburg, AZThe student pilot’s failure to relinquish flight controls and premature flap reduction during approach to land.NTSB CEN18LA151Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Cullman, ALThe pilot’s inadvertent engine shutdown due to excessive leaning of the engine and his subsequent inability to restart the engine.NTSB CEN18FA147Accident · 2 fatalField investigationFinal reportNorth American SNJ 5 · Kingsville, TXThe pilot's failure to maintain airspeed during a steep turn after takeoff, resulting in an exceedance of the airplane's critical angle of attack and a subsequent accelerated stall at an altitude too low for recovery.NTSB ANC18LA033Accident · Serious injuriesLimited investigationFinal reportNorth Wing Uum Sport X2-N · Pahrump, NVThe pilot's improper landing flare, which resulted in a fractured engine mount sway bar and subsequent difficulty controlling the airplane, and his inadvertent application of throttle pedal during landing, which resulted in a loss of control.NTSB GAA18CA240Accident · No injuriesData collectionFinal reportBrown Joseph Sportsman GS-2 · Kalispell, MTThe pilot’s selection of an unsuitable snow-covered airstrip for landing, which resulted in a nose-over.NTSB ERA18LA135Accident · Serious injuriesClass 3 · LimitedFinal reportHeard Alan E Mosquito XE · Albion, NYThe pilot's inadvertent, improper configuration of the engine fuel system, which resulted in an excessively lean air-to-fuel ratio and resulted in a loss of engine power; and the pilot's subsequent failure to maintain main rotor rpm following the loss of…NTSB CEN18LA148Accident · Serious injuriesLimited investigationFinal reportMaule M 5-235C · Roxbury, KSThe pilot's failure to maintain directional control during takeoff from a road, which resulted in impact with a sign.NTSB CEN18LA146Accident · Minor injuriesLimited investigationFinal reportCessna T303 · Pine Ridge, SDThe airplane’s inadvertent encounter with severe icing conditions during descent, which resulted in structural icing, the pilot’s inability to maintain altitude, and an emergency landing. Contributing to the accident was an incomplete preflight weather…NTSB GAA18CA589Accident · No injuriesData collectionFinal reportPiper PA28R · Camarillo, CAThe flight instructor's improper landing flare, which resulted in a hard landing.NTSB GAA18CA231Accident · No injuriesData collectionFinal reportCessna 162 · York, PAThe pilot’s improper landing flare, which resulted in a hard, bounced landing and a nose landing gear collapse.NTSB GAA18CA227Accident · No injuriesData collectionFinal reportIrvin Stephen D Rutan Long E Z · Tucson, AZThe pilot’s excessive ground speed and loss of directional control while exiting the taxiway.NTSB GAA18CA223Accident · No injuriesData collectionFinal reportKen Olson Scamp · Raymond, WAThe pilot's failure to maintain a proper landing flare, which resulted in an aerodynamic stall, bounced landing, and subsequent secondary stall during a go-around attempt.NTSB GAA18CA222Accident · No injuriesData collectionFinal reportPiper PA 25-235 · Saratoga Springs, NYThe glider pilot’s failure to maintain pitch during a CG aerotow, which resulted in the loss of control of the tow airplane.