NTSB investigations
16 cases where NTSB found Neurological.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 3 |
| 2017 | 1 |
| 2018 | 1 |
| 2020 | 1 |
| 2022 | 3 |
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\", '02012045')) 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", '02012045')) 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 DCA23LA109Accident · 1 fatalClass 3 · LimitedFinal reportEmbraer S A ERJ 170-200 LR · Montgomery, ALThe ramp agent’s cognitive impairment, which resulted in her (1) inconsistent behavior with trained procedures and pre landing briefings, (2) presence on the left side of the airplane while the left engine was still operating, and (3) subsequent ingestion…NTSB CEN23LA041Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Saint Joseph, MOThe pilot lost control of the airplane while on the ground due to temporary incapacitation.NTSB ERA22LA414Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-39 · Caldwell, NJThe pilot’s acute cerebrovascular event, which caused symptoms that diminished his situational awareness and prompted him to abort the takeoff, resulting in a runway excursion.NTSB ERA20LA076Accident · Serious injuriesClass 3 · LimitedFinal reportMagni M-24 Plus · Nashua, NHThe pilot's incapacitation during the takeoff roll due to a stroke.NTSB ERA18FA187Accident · 2 fatalField investigationFinal reportRobinson R44 · Williamsburg, VAThe pilot's failure to safely operate the helicopter due to his impaired cognitive and physical abilities, which resulted in a loss of control.NTSB ERA18FA004Accident · 2 fatalField investigationFinal reportCessna 401 · Salters, SCThe pilot's decision to attempt a low-altitude aerobatic maneuver in a non-aerobatic airplane, and his subsequent failure to maintain control of the airplane during the maneuver. Contributing to the accident was the pilot's impairment by the effects of…NTSB CEN17FA046Accident · 1 fatalField investigationFinal reportGordon Pegazair P 100 · Mt Vernon, INThe pilot's failure to maintain airplane control, which resulted in a collision with terrain. Contributing to the accident was the pilot's impairment resulting from the combination of his progressive degenerative neurologic condition and his use of alcohol.NTSB WPR16FA157Accident · 1 fatalField investigationFinal reportArion Lightning LS-1 · Van Nuys, CAThe pilot's loss of airplane control due to an exceedance of the airplane's critical angle of attack, which resulted in an accelerated stall and subsequent impact with a building. Contributing to the accident was the pilot's unreported physiological…NTSB WPR16FA087Accident · 2 fatalField investigationFinal reportNorth American AT 6A · Astoria, ORThe pilot's loss of aircraft control during a low-altitude ash dispersal maneuver. Contributing to the accident was his degraded performance due to his medical conditions.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 WPR13FA208Accident · 1 fatalField investigationFinal reportBell 206B · Shepherd, MTThe pilot’s loss of control while maneuvering during low-altitude operations due to sudden neurological impairment or incapacitation and the helicopter’s subsequent collision with power lines.NTSB CEN12FA534Accident · 1 fatalField investigationFinal reportBeech G18 - S · Taylorville, ILThe pilot's failure to maintain adequate airspeed and use the appropriate flaps setting during sport-parachuting operations, which resulted in an aerodynamic stall/spin and a subsequent loss of control. Contributing to the accident was the pilot’s failure to…NTSB CEN11FA480Accident · 1 fatalField investigationFinal reportTaylorcraft DCO-65 · Boyne City, MIThe pilot failed to maintain airplane control while maneuvering at low altitude, which resulted in a stall/spin and impact with the terrain.NTSB WPR11FA268Accident · 1 fatalField investigationFinal reportTrusty Thorp T-18 · Tehachapi, CAThe pilot’s failure to maintain clearance from mountainous terrain during cruise flight, which resulted from his impairment or incapacitation due to multiple medical conditions and sedating medication.NTSB WPR11LA044Accident · No injuriesLimited investigationFinal reportPiper PA30 · Tucson, AZThe pilot's impairment by an undiagnosed medical condition, which resulted in a loss of directional control and subsequent collision with a building during the landing roll. Contributing to the accident was the pilot's decision to fly when he was not feeling…NTSB ERA09CA034Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5B · Bridgeport, CTThe pilot's loss of directional control during landing and while suffering symptoms of vertigo.