NTSB investigations, 2009
27 cases where the defining event was Miscellaneous/other.
Cases per year
| 2008 | 26 |
|---|---|
| 2009 | 27 |
| 2010 | 39 |
| 2011 | 52 |
| 2012 | 66 |
| 2013 | 48 |
| 2014 | 41 |
| 2015 | 39 |
| 2016 | 56 |
| 2017 | 42 |
| 2018 | 54 |
| 2019 | 36 |
| 2020 | 31 |
| 2021 | 18 |
| 2022 | 27 |
| 2023 | 28 |
| 2024 | 33 |
| 2025 | 54 |
| 2026 | 22 |
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 year(c.\"eventDate\") = 2009
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '900')
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 year(c."eventDate") = 2009 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '900') 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 ANC10LA007Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Palmer, AKThe pilot's selection of unsuitable terrain for takeoff.NTSB ANC10CA009Accident · No injuriesData collectionFinal reportCessna 182C · Kotzebue, AKThe pilot's failure to maintain directional control and his selection of unsuitable terrain for takeoff.NTSB WPR10CA019Accident · Minor injuriesData collectionFinal reportCessna 172S · Honolulu, HIThe student pilot's distraction and subsequent loss of airplane control after the cabin window opened during the takeoff roll.NTSB WPR10LA022Accident · No injuriesLimited investigationFinal reportCessna 208B · Molokai, HIThe failure of the ramp agent to use a tail stand.NTSB CEN09FA610Accident · 1 fatalField investigationFinal reportMooney M20M · Albany, INThe incapacitation of the pilot during high-altitude cruise flight for undetermined reasons.NTSB ERA09LA544Accident · No injuriesLimited investigationFinal reportCelier Xenon RST · Mount Pleasant, SCThe gyroplane's inadequate climb performance for undetermined reasons.NTSB ERA09CA548Accident · No injuriesData collectionFinal reportPiper PA-20 · Herlong, FLThe pilot’s improper visual lookout while taxing on soft terrain.NTSB WPR09LA436Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Torrance, CAA main rotor overspeed due to the pilot’s failure to maintain rotor RPM within allowable limits during a practice autorotation.NTSB ANC09CA089Accident · No injuriesData collectionFinal reportAeronca 15AC · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a runway excursion, collision with terrain, and nose over.NTSB ERA09LA435Accident · 1 fatalLimited investigationFinal reportBeech B90 · West Point, VAThe inadvertent deployment of the instructor's reserve parachute.NTSB CEN09LA502Accident · Serious injuriesLimited investigationFinal reportCessna 337F · Frankfort, MIThe pilot intentionally attempting to take off with an inoperative engine, which lead to the airplane's inability to maintain airspeed in the initial climb, resulting in a stall and impact with trees.NTSB WPR09TA356Accident · 1 fatalFinal reportBell 212 · Willow Creek, CAThe rappeller's failure to properly latch the rappelling harness to the rappelling assembly before exiting the helicopter.NTSB ERA09LA358Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Plymouth, MAThe CFI's inadequate preflight planning and delay to abort the takeoff from the soft takeoff area.NTSB DCA09WA058Incident · No injuriesForeign investigationBoeing 767 · Taipei, Taiwan, TaiwanOn June 6, 2009, Japan Airlines flight 653, a Boeing 767-300, registration JA-613J, experienced a cabin fire during approach to Taoyuan International Airport (TPE/RCTP), Taipei, Taiwan. The remains of a charred lighter were found in the nook between a seat…NTSB CEN09CA271Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Harlingen, TXThe pilot's decision to leave the helicopter unattended with the engine running in gusty wind conditions.NTSB WPR09LA218Accident · No injuriesLimited investigationFinal reportWeinberg RV-6 · Sparks, NVThe pilot's failure to follow the pre-takeoff checklist that resulted in the canopy opening during takeoff, which created a distraction, and his failure to maintain aircraft control during landing.NTSB ERA09CA276Accident · Serious injuriesData collectionFinal reportArbc Inc DBA Lindstrand 60X · Louisville, KYThe passenger's inadequate bracing during landing.NTSB CEN09CA257Accident · No injuriesData collectionFinal reportEnstrom 280FX · Dacono, COA partial loss of engine power for undetermined reasons.NTSB ERA09IA240Incident · 1 fatalIncident investigationFinal reportBeech B200 · Fort Myers, FLThe pilot’s abnormal heart rhythm resulting in incapacitation.NTSB WPR09LA184Accident · No injuriesLimited investigationFinal reportSikorsky CH-54B · Corvallis, ORThe improper assembly of main rotor blade control components by the operator's maintenance personnel, which resulted in the main rotor blade's divergent path and their contact with the tail rotor drive shaft during ground operation following landing.NTSB WPR09LA151Accident · No injuriesLimited investigationFinal reportGates Learjet Learjet 55 · Casper, WYThe flight crew's failure to follow the manufacturer’s aircraft flight manual emergency procedures following a rejected takeoff that required a high energy stop inspection. Contributing to the accident was the flight's exceedence of the aircraft's maximum…NTSB CEN09CA223Accident · No injuriesData collectionFinal reportBeech D35 · Taos, NMThe failure of the student pilot to complete the before landing checklist. Contributing to the accident was his failure to lower the landing gear before landing.NTSB WPR09CA155Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Douglas, AZThe pilot's failure to properly secure the helicopter prior to exiting the aircraft.NTSB WPR09CA135Accident · No injuriesData collectionFinal reportCosmos Phase 2 · Salome, AZThe pilot's encounter with a rut while landing on an unimproved dry lake bed.NTSB WPR09LA130Accident · 1 fatalLimited investigationFinal reportToland S/Thornburgh J Twin 503SL · Torrance, CAThe passenger’s inadvertent activation of the engine throttle.NTSB ERA09CA138Accident · No injuriesData collectionFinal reportMD Helicopter 369E · Atlanta, GAWind gusts during engine shutdown, which resulted in the main rotor blades contacting the tailboom.NTSB ERA09FA133Accident · No injuriesField investigationFinal reportPiper PA-46-500TP · Milton, FLThe pilot's intentional inflight abandonment of the airplane.