NTSB investigations
24 cases where NTSB found Physical environment, general.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2010 | 2 |
| 2011 | 3 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 2 |
| 2017 | 2 |
| 2020 | 2 |
| 2023 | 2 |
| 2024 | 2 |
| 2025 | 1 |
Where
Open the mapLatest cases
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\", '030200')) 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", '030200')) 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 DCA25LA102Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787 · Ojai, CAAn encounter with turbulence during descent, which resulted in a serious injury to a flight attendant.NTSB DCA25LA055Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787-9 · Pacific Ocean, Hong Kong SAR ChinaAn encounter with unexpected turbulence during descent.NTSB ERA24LA227Accident · 1 fatalClass 3 · LimitedFinal reportBrallier Scott Glasair I · Gulf of Mexico, FLThe non-instrument-rated pilot’s loss of airplane control due to spatial disorientation while flying over water in dark night conditions. Contributing to the accident was the pilot’s decision to conduct the overwater flight in conditions conducive to the…NTSB WPR24LA048Accident · Minor injuriesClass 4 · LimitedFinal reportFlight Design Ctls · Hungry Horse, MTThe pilot's inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN23LA373Accident · No injuriesClass 4 · LimitedFinal reportCessna 150D · New Haven, INThe pilot’s loss of directional control while landing, which resulted in a runway excursion, impact with corn stalks, and subsequent nose over.NTSB CEN20LA305Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA28 · San Antonio, TXThe pilot’s improper decision to take off in an airplane over maximum gross weight and with a tailwind, which prevented the airplane from climbing.NTSB CEN20CA230Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R22 · El Campo, TXThe pilot's failure to maintain adequate clearance from the rice vegetation, which resulted in the helicopter's impact with terrain.NTSB GAA17CA496Accident · Minor injuriesData collectionFinal reportMIke Reed Super Cub · Murphy, IDThe pilot’s use of excessive brake pressure during the landing roll, which resulted in a nose-over.NTSB GAA17CA179Accident · No injuriesData collectionFinal reportBurkhart Grob G 109B · Mokuleia, HIThe failure of the upper rudder hinge during flight due to severe corrosion. Contributing to the accident were the pilot’s inadequate preflight inspection and the lack of an annual inspection.NTSB ERA17LA006Accident · No injuriesLimited investigationFinal reportPiper PA24 · Hollywood, ALA failure of the fuel tank selector valve in a partially closed position, which resulted in fuel starvation to the engine and a total loss of engine power.NTSB GAA16CA248Accident · No injuriesData collectionFinal reportLuscombe 8 · Blue Bell, PAThe pilot's failure to maintain directional control during the takeoff roll and the flight instructor's delayed remedial action, which resulted in runway excursion, and collision with a ditch.NTSB WPR14LA130Accident · No injuriesLimited investigationFinal reportGrumman G164 - A · Caruthers, CAAn undetected fatigue crack in the landing gear leg, which initiated at an electrical arc-induced damage site of undetermined origin and resulted in landing gear failure. Contributing to the severity of damage to the airplane was the close proximity of an…NTSB ERA13LA279Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Louisville, KYThe pilot's failure to set the correct flap position before takeoff and his inadequate preflight planning, which resulted in the operation of the airplane over the maximum allowable gross weight, both of which led to an aerodynamic stall at too low an…NTSB CEN13LA034Accident · 2 fatalLimited investigationFinal reportUS Light Hornet · Mont Belvieu, TXThe pilot’s inadequate airspeed management while maneuvering in gusty wind conditions, which resulted in an aerodynamic stall. Contributing to the accident was the airplane’s low altitude, which did not allow for a stall recovery.NTSB CEN12CA403Accident · No injuriesData collectionFinal reportAyres S2R-G10 · Minden, NEThe pilot’s failure to maintain clearance from the wake turbulence from a previous pass.NTSB WPR12LA174Accident · No injuriesLimited investigationFinal reportWillerton Vans RV6A · Sequim, WAThe pilot's inadequate landing flare, which resulted in a hard landing.NTSB CEN11CA525Accident · No injuriesData collectionFinal reportBell 47G-2A · Nicolett, MNThe pilot's failure to maintain control of the helicopter while maneuvering during an aerial application flight.NTSB ERA11FA374Accident · 1 fatalField investigationFinal reportBinkley Richard Sonex · Calhoun, GAThe total loss of engine power for reasons that could not be determined because postimpact fire damage precluded a thorough examination of the engine.NTSB WPR11CA189Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Salt Lake City, UTThe student pilot's inadvertent action of pulling out the engine's mixture control lever to idle cutoff that resulted in a complete loss of engine power.NTSB CEN10FA299Accident · 1 fatalField investigationFinal reportBeech G35 · Marble, COThe pilot’s miscalculation of the airplane's turn radius and climb capabilities at high altitude, resulting in controlled flight into terrain. Contributing to the accident was the pilot's lack of mountain flying experience and restricted visibility due to the…NTSB ERA10LA247Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Clemson, SCThe airplane's inadvertent collision with deer during a night takeoff. Contributing to the accident was the lack of a deer barrier between the airport and an adjacent wooded area.NTSB ERA09CA535Accident · No injuriesData collectionFinal reportC A Tecnam P2002 Sier · Enterprise, ALThe student pilot's failure to maintain control during the landing roll.NTSB WPR09FA414Accident · 1 fatalField investigationFinal reportPiper PA-25 · Creswell, ORThe pilot's failure to maintain aircraft control during takeoff for a glider tow operation. Contributing to the accident were the tow pilot's impairment due to marijuana use and the low altitude of the flight that reduced the time available to recover from an…NTSB DFW08LA122Accident · 1 fatalLimited investigationFinal reportRobinson R44 · Bartlett, TXThe pilot's failure to maintain tail rotor clearance from terrain (embankment) during takeoff.