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 ERA14LA242Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Georgetown, DEThe pilot’s improper preflight planning and in-flight fuel management, which resulted in fuel starvation and a total loss of engine power. Also causal to the accident was the pilot’s failure to see and avoid the wires on the airport boundary.NTSB WPR14FA194Accident · 1 fatalField investigationFinal reportAero Commander 500 S · Fort Huachuca, AZThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack after a total loss of engine power during the takeoff initial climb, which resulted in an aerodynamic stall and impact with terrain. The reason for…NTSB ERA14CA251Accident · No injuriesData collectionFinal reportChance Vought F4U 4 · Atlanta, GAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB WPR14CA202Accident · No injuriesData collectionFinal reportPiper J3C 65 · Tucson, AZThe pilot's failure to maintain directional control during the landing roll.NTSB CEN14CA250Accident · No injuriesData collectionFinal reportSantschi Chris A Vans RV8 · Bonne Terre, MOThe pilot's failure to maintain aircraft control on takeoff.NTSB WPR14CA193Accident · No injuriesData collectionFinal reportKalman George Lancair 360 · Grand Canyon, AZThe pilot's inadequate flare, which resulted in a hard landing.NTSB WPR14CA192Accident · Minor injuriesData collectionFinal reportCessna 120 · Colville, WAThe pilot's failure to maintain directional control during the landing roll.NTSB WPR14CA190Accident · No injuriesData collectionFinal reportAviat A 1B · Hayden, IDA partial loss of engine power due to encounter with weather conditions conducive to carburetor icing. Contributing the accident was the pilot's inadequate weather planning.NTSB ANC14CA036Accident · No injuriesData collectionFinal reportCessna 208B · Aniak, AKThe pilot's failure to maintain clearance from a forklift while taxiing.NTSB ERA14CA240Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Norfolk, VAThe student pilot's failure to maintain directional control during takeoff.NTSB WPR14LA205Accident · No injuriesLimited investigationFinal reportCessna 180A · Nampa, IDThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB WPR14LA201Accident · No injuriesLimited investigationFinal reportSchweizer G 164B · Biggs, CAThe assembler’s improper fabrication of a fuel line (hose) and the subsequent failure to verify that it was not occluded, which resulted in fuel starvation and a total loss of engine power during takeoff.NTSB ERA14CA239Accident · Serious injuriesData collectionFinal reportTaylorcraft BC 65 · Summerville, GAThe pilot's selection of an inadequate altitude during low level maneuvering, which resulted in an in-flight collision with trees.NTSB DCA14CA093Accident · No injuriesData collectionFinal reportMcdonnell Douglas MD90 - 30 · Boston, MAthe captain's failure to verify the communications between himself and the tug operator, which resulted in him applying of brakes while the airplane was being pushed back from the gate by the tug with tow bar attached.NTSB ERA14CA234Accident · Minor injuriesData collectionFinal reportSam R Peachey Just Aircraft Highla · Roxbury, PAThe pilot's failure to maintain adequate airspeed during low altitude maneuvering.NTSB ERA14CA233Accident · Minor injuriesData collectionFinal reportPiper PA 28-180 · Indian Trail, NCThe pilot's improper flap retraction during a short field takeoff, which resulted in the aircraft experiencing an aerodynamic stall and impact with trees.NTSB CEN14CA237Accident · No injuriesData collectionFinal reportMooney M20F · Dowling, MIThe pilot's failure to maintain control during landing.NTSB ERA14FA232Accident · 1 fatalField investigationFinal reportNavion G · Hamilton Township, NJThe pilot's mismanagement of the onboard fuel supply, which resulted in fuel starvation to the engine and a subsequent loss of engine power. Contributing to the death of the right front passenger was the inadequate occupant restraint.NTSB CEN14LA243Accident · 1 fatalLimited investigationFinal reportHoffius Stowe Challenger II · Attica, INThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack while maneuvering at low altitude, which led to an aerodynamic stall and loss of control. Contributing to the accident was the installation of an…NTSB CEN14LA235Accident · Minor injuriesLimited investigationFinal reportPazmany PL 4 · Yates City, ILA loss of propeller thrust due to a failure of the reduction drive unit resulting from the improper installation of the unit. Contributing to the accident was a lack of documentation for the reduction drive unit installation.NTSB CEN14CA238Accident · No injuriesData collectionFinal reportAmerican Legend AL-3 · Osage, ARThe pilot's repeated attempts to take off from an unimproved field with tall grass.NTSB ERA14LA244Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Brooksville, FLThe pilot’s loss of directional control while landing at night, which resulted in a runway excursion and collision with airport signage. Contributing to the accident was the total loss of electrical power, which necessitated the pilot having to land without…NTSB ERA14LA235Accident · No injuriesLimited investigationFinal reportPacific Aerospace 750XL · Warrenton, VAThe pilot’s improper landing flare, which resulted in a hard landing and separation of the left main landing gear.NTSB ERA14FA231Accident · 3 fatalField investigationFinal reportEagle C-7 · Ruther Glen, VAThe pilot’s inadequate approach and his failure to maintain clearance from power lines, which resulted in a subsequent fire.NTSB ERA14CA243Accident · No injuriesData collectionFinal reportPiper PA 22-150 · Meadville, PAThe pilot's failure to maintain directional control during an attempted go around in gusty wind conditions which resulted in a collision with terrain.NTSB ERA14CA238Accident · Serious injuriesData collectionFinal reportNorth American AT6 - C · Roxbury, NYThe pilot's failure to maintain adequate obstacle clearance, which resulted in the inflight collision with a power line.NTSB ERA14CA230Accident · No injuriesData collectionFinal reportCessna 172S · Deland, FLThe student pilot's failure to maintain control of the airplane during the landing, and the flight instructor's inadequate supervision of the student pilot resulting in abnormal runway contact and damage to the airplane.NTSB CEN14LA239Accident · No injuriesLimited investigationFinal reportCessna 525C · Columbus, OHThe flight crew’s decision to attempt an engine start in conditions that exceeded the engine's maximum allowable ground start crosswind component limitation.NTSB CEN14CA236Accident · No injuriesData collectionFinal reportMorris Thomas Lee Stolp Strdstr SA300 · Lincoln, NEThe pilot's loss of directional control while landing in gusty crosswinds in a tail wheel equipped airplane.NTSB WPR14FA183Accident · 2 fatalField investigationFinal reportCessna 150 - F · Santa Clara, UTThe flight instructor’s failure to arrest the airplane’s descent and maintain clearance from mountainous terrain while maneuvering at a low altitude.NTSB ERA14LA227Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Covington, TNThe pilot’s improper preflight and in-flight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power over unsuitable terrain.NTSB CEN14LA233Accident · No injuriesLimited investigationFinal reportPiper PA 32-300 · Lancaster, OHFuel starvation due to the deterioration of the fuel selector valve, which allowed fuel to be fed from only the right tip tank. Contributing to the accident was the inadequate annual inspection, which failed to detect the deteriorated valve.NTSB WPR14FA188Accident · 2 fatalField investigationFinal reportMooney M20C · Cody, WYThe non-instrument rated pilots’ decision to continue flight into known instrument meteorological conditions over mountainous terrain, which resulted in controlled flight into terrain.NTSB WPR14CA187Accident · No injuriesData collectionFinal reportPiper PA28 - 181 · Ho'olehua, HIThe pilot's improper landing flare, which resulted in a hard landing.NTSB CEN14LA241Accident · Serious injuriesLimited investigationFinal reportKinsler Arthur Paul Kinsler Lancair/Mkii · Crivitz, WIThe improper installation of the hose fuel fitting, which resulted in the fitting becoming disconnected and the subsequent loss of engine power due to fuel starvation.NTSB WPR14LA240Accident · No injuriesLimited investigationFinal reportCessna T207A · Rock Springs, WYMaintenance personnel’s application of insufficient torque to the engine cylinder through bolts during replacement of the No. 1 cylinder, which resulted in the displacement of the No. 2 main bearing, the bearing shifting, and a catastrophic engine failure.NTSB CEN14FA230Accident · No injuriesField investigationFinal reportPiper PA 25-235 · Northglenn, COThe pilot's decision to operate the banner-tow flight below the minimum safe altitude specified by federal regulation, which likely limited his ability to recover from a potential loss of airspeed due to a gusting wind condition. Also causal was the pilot’s…NTSB WPR14FA182Accident · 1 fatalField investigationFinal reportBoeing E75 · Fairfield, CAThe pilot's failure to maintain clearance from the runway during a low-level aerobatic maneuver due to his impairment by an over-the-counter antihistamine. Contributing to the severity of the pilot's injuries were the pilot's lack of fire protective clothing,…NTSB ERA14LA223Accident · No injuriesLimited investigationFinal reportMesserschmitt-Bolkow-Blohm BK 117 · Hamburg, NYWear in the left cabin door assembly parts, which resulted in the door partially opening in flight, dislodging from the lower door track assembly, and then separating from the helicopter.NTSB ERA14LA222Accident · Minor injuriesLimited investigationFinal reportChampion 7GCAA · Bardwell, KYThe failure of the pilot to maintain airspeed while maneuvering shortly after takeoff, resulting in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall, uncontrolled descent, and impact with the ground.NTSB ERA14LA219Accident · Serious injuriesLimited investigationFinal reportCzech Sport Aircraft A S Sportcruiser · Advance, NCThe pilot’s failure to apply carburetor heat during a descent with reduced engine power while operating in conditions conducive to carburetor icing, which resulted in a total loss of engine power.NTSB ERA14CA220Accident · Serious injuriesData collectionFinal reportSchleicher ASW 20 · Monroe, GAThe pilot's improper selection of an off-airport landing site and his subsequent failure to maintain clearance from trees during an off airport landing.NTSB ANC14CA027Accident · No injuriesData collectionFinal reportTaylorcraft BC12 D · Wasilla, AKThe pilot's inadequate weather evaluation, which resulted in a turbulence encounter at low altitude and collision with trees. Contributing to the accident was the pilot's lack of knowledge of local wind conditions.NTSB WPR14CA184Accident · No injuriesData collectionFinal reportCessna 180D · Murieta, CAThe pilot's loss of directional control during takeoff. Contributing to the accident was the pilot's failure to abort the takeoff at the initial veer off.NTSB CEN14CA231Accident · Minor injuriesData collectionFinal reportPiper J3C 65 · Connersville, INThe pilot's inability to control the airplane while taxiing due to a strong crosswind condition.NTSB ANC14CA026Accident · No injuriesData collectionFinal reportCessna 170B · Soldotna, AKThe pilot's failure to recognize a wind shift, resulting in a tailwind landing, loss of control, and ground loop.NTSB ERA14LA218Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Middlesboro, KYThe pilot's failure to maintain airplane control during the landing approach due to his diverted attention to the partially opened main cabin door and the unsecured dog. Contributing to the accident was the pilot's failure to securely latch the main cabin…NTSB CEN14CA227Accident · No injuriesData collectionFinal reportPiper PA 24-250 · New Braunfels, TXThe loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight planning and inflight decision making.NTSB ERA14CA217Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Frederick, MDThe student pilot's failure to maintain directional control during the hover, and the flight instructors lack of remedial action, resulting in a dynamic rollover and structural damage to the helicopter.NTSB ERA14CA216Accident · No injuriesData collectionFinal reportAgusta Aerospace AW119 Mkii · Lumberton, NJThe flightcrew's improper recovery from a simulated engine failure after takeoff. Contributing to the accident was the flight instructor's failure to clarify who had control of the helicopter.