NTSB investigations
64 cases where the probable cause includes Miscellaneous.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 5 |
| 2010 | 6 |
| 2011 | 3 |
| 2012 | 4 |
| 2013 | 5 |
| 2014 | 2 |
| 2015 | 9 |
| 2016 | 4 |
| 2017 | 3 |
| 2018 | 3 |
| 2019 | 2 |
| 2020 | 2 |
| 2021 | 3 |
| 2022 | 3 |
| 2023 | 2 |
| 2024 | 7 |
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 f.\"inProbableCause\" AND starts_with(f.\"findingCode\", '0205')) 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 f."inProbableCause" AND starts_with(f."findingCode", '0205')) 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 CEN25LA049Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Camdenton, MOThe pilot’s poor flight planning which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN25LA022Accident · No injuriesClass 4 · LimitedFinal reportMagniflight M24 Orion · Valmeyer, ILThe pilot’s loss of control due to flight control interference by the passenger during takeoff.NTSB ERA24LA346Accident · 1 fatalClass 4 · LimitedFinal reportPiper J3 · Mooresburg, TNThe pilot’s intentional flight into a building as an act of suicide.NTSB WPR24LA193Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Monument Hills, CAA total loss of engine power for reasons that could not be determined.NTSB WPR24LA142Accident · 1 fatalClass 3 · LimitedFinal reportUltramagic Z-90 · Del Mar, CAThe passenger’s intentional departure from the balloon in flight as an act of suicide.NTSB CEN24LA157Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-28-161 · Montmorenci, INThe pilot’s intentional flight into terrain as an act of suicide.NTSB CEN24LA099Accident · 1 fatalClass 4 · LimitedFinal reportTextron 172S · Direct, TXThe pilot died by suicide.NTSB CEN23FA155Accident · 1 fatalClass 3 · FieldFinal reportJunior Ace · Mammoth Springs, ARThe pilot’s intentional flight into terrain as an act of suicide.NTSB CEN23LA093Accident · 1 fatalClass 4 · LimitedFinal reportCirrus Design SR20 · Indianapolis, INThe pilot’s intentional flight into terrain as an act of suicide.NTSB CEN22LA428Accident · No injuriesClass 4 · LimitedFinal reportBeech C90A · Tupelo, MSThe uncertificated pilot’s criminal act of stealing the airplane and later performing an off-airport landing that resulted in an impact with terrain.NTSB ERA22LA375Accident · 1 fatalClass 4 · LimitedFinal reportCessna 172 · Atlantic Ocean (Atlantic Ocean)The pilot's suicide.NTSB CEN22LA122Accident · Serious injuriesClass 4 · LimitedFinal reportBell 206 · Eldorado, ILOverheating of two lithium batteries in the paramedic’s flight suit pocket resulting in an explosion and fire that seriously injured the paramedic as the helicopter was about to take off.NTSB WPR22LA049Accident · Minor injuriesClass 4 · LimitedFinal reportTaylorcraft BL-65 · New Cuyama, CAThe pilot’s decision to intentionally crash the airplane.NTSB CEN22FA017Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-181 · Buxton, NDThe pilot’s intentional flight into terrain as an act of suicide.NTSB ERA21LA293Accident · Minor injuriesClass 4 · LimitedFinal reportErcoupe 415-C · Frostproof, FLThe pilot’s loss of directional control during takeoff as a result of a child reaching for and manipulating the flight controls.NTSB WPR20LA279Accident · FatalClass 4 · LimitedFinal reportCessna 150 · Quillayute, WAThe airplane’s descent into trees and subsequent impact with terrain for undetermined reasons.NTSB CEN20CA193Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Ionia, MIThe pilot's failure to maintain directional control during landing. Contributing was the pilot getting his shoe caught in the rudder pedal.NTSB GAA20CA022Accident · No injuriesData collectionFinal reportBeech 36 · Douglas, GAThe pilot's failure to extend the landing gear due to intoxication during an unauthorized flight.NTSB ERA19FA184Accident · 1 fatalClass 2 · FieldFinal reportMooney M20J · Cape May, NJThe pilot's intentional flight into water as an act of suicide.NTSB DCA18CA294Accident · Serious injuriesData collectionFinal reportAirbus A321 · Dallas, TXa passenger leaving a bag in the aisle that the flight attendant tripped over.NTSB CEN18LA361Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 55 · Waupaca, WIThe total loss of engine power due to fuel exhaustion.NTSB CEN18FA326Accident · 1 fatalField investigationFinal reportCessna 525 · Payson City, UTThe pilot's intentional flight into his residence.NTSB GAA17CA520Accident · Serious injuriesData collectionFinal reportCessna 680 · Wilmington, DEThe passenger’s inadvertent slip on the airplane's air stairs during deplaning, which resulted in a broken ankle.NTSB CEN17CA294Accident · Minor injuriesData collectionFinal reportAir Tractor AT 502B · Harrold, SDThe pilot’s improper attempt at a low-pass maneuver, which resulted in a collision with a tractor.NTSB ERA17LA158Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Euharlee, GAThe NTSB did not determine the probable cause of this event and does not plan to issue a report or open a public docket. The investigation of this event is being conducted under the jurisdiction of the Federal Bureau of Investigation.NTSB ANC17FA012Accident · 2 fatalField investigationFinal reportPiper PA 11 · Aniak, AKThe pilot's intentional flight of the airplane into terrain in an act of suicide.NTSB DCA17CA096Accident · Serious injuriesData collectionFinal reportBoeing 717 200 · Hopewell, VAthe flight attendant's inadvertent bump into a retractable galley tray.NTSB ERA17FA011Accident · 1 fatalField investigationFinal reportPiper PA 34-200 · East Hartford, CTThe NTSB did not determine the probable cause of this event and does not plan to issue a report or open a public docket. The investigation of this event is being conducted under the jurisdiction of the Federal Bureau of Investigation.NTSB CEN16LA203Accident · 1 fatalLimited investigationFinal reportCessna 150 · Penwell, TXThe pilot’s intentional flight into a silo.NTSB ANC16LA011Accident · 1 fatalLimited investigationFinal reportCessna 172 · Anchorage, AKThe pilot's intentional flight into a building.NTSB CEN16LA018Accident · No injuriesLimited investigationFinal reportDiamond DA20-C1 · Waskom, TXThe pilot's decision to operate the airplane without the owner’s permission and his lack of preflight planning, which resulted a total loss of engine power due fuel exhaustion.NTSB CEN15CA340Accident · Serious injuriesData collectionFinal reportThunder & Colt AX8 105S2 · Albuquerque, NMThe pilot did not properly brace herself during the landing, which resulted in a broken ankle and leg.NTSB DCA15CA152Accident · Serious injuriesData collectionFinal reportAirbus Industrie A320 212 · Boston, MAan inadvertent fall by the passenger while exiting the lavatory when the seat belt light was illuminated.NTSB ERA15LA218Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Kearny, NJThe deliberate concealment and reuse of an unairworthy tail rotor driveshaft by unknown personnel, which resulted in an overstress separation at a bonded flange adapter as a result of driveshaft imbalance.NTSB WPR15FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 172S · Davenport, CAUndetermined because the airplane was not located.NTSB WPR15LA150Accident · 1 fatalLimited investigationFinal reportCessna 206H · Redding, CAThe pilot's intentional descent into terrain.NTSB CEN15LA122Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Routt County, COThe pilot’s intentional flight into terrain.NTSB CEN15FA101Accident · 1 fatalField investigationFinal reportPiper PA 28RT-201T · Brighton, COThe pilot's intentional descent into the terrain.NTSB ERA14LA290Accident · 1 fatalLimited investigationFinal reportCameron Balloons US Z-225 · Spring City, PAThe pilot's fall from the balloon’s basket during touchdown in a field for reasons that could not be determined based on the available evidence, which resulted in his fatal injury.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 ERA13FA330Accident · 1 fatalField investigationFinal reportCessna 172M · Fredericksburg, VAThe pilot's intentional descent into the ground to commit suicide.NTSB CEN13CA423Accident · No injuriesData collectionFinal reportBeech C23 · Augusta, KSThe pilot did not obtain adequate airspeed and clearance from obstructions during a grass field takeoff.NTSB CEN13LA384Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Heth, ARThe partial collapse of the right main landing gear during landing due to an improper previous weld repair to the right main landing gear and subsequent corrosion, which resulted in a loss of directional control and impact with terrain.NTSB WPR13LA203Accident · 1 fatalLimited investigationFinal reportHoffman RV-4 · Bullhead City, AZThe pilot’s suicidal act.NTSB ERA13FA101Accident · 3 fatalField investigationFinal reportPiper PA-30 · Jasper, ALThe student pilot’s poor judgment to take a multiengine airplane for which he did not have experience or permission to operate and depart into night instrument meteorological conditions, which resulted in a loss of airplane control and impact with terrain.NTSB ERA12LA578Accident · 1 fatalLimited investigationFinal reportCessna 172B · Atlantic Ocean (Atlantic Ocean)The pilot’s suicidal act.NTSB ERA12LA307Accident · No injuriesLimited investigationFinal reportRice Leo B Kitfox Series 5 · Port Canaveral, FLImpingement of the elevator control by foreign objects (clamp, glove) left in the flight control path by the pilot/owner or maintenance personnel.NTSB DCA12CA045Accident · Serious injuriesData collectionFinal reportBoeing 767 · Angers, Francethe flight attendant inadvertently tripping over a passenger's luggage strap that was protruding into the isle.NTSB ANC12CA018Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Beluga, AKGround personnel's movement of cargo in windy conditions, which allowed a previously secured cargo sack to blow into the main rotor blades.NTSB ERA12CA291Accident · Serious injuriesData collectionFinal reportNorth American SNJ-6 · Kissimmee, FLThe passenger’s fall from the airplane during a normal egress.