NTSB investigations, 2008
17 cases where the sequence of events included Unknown or undetermined.
Cases per year
| 2008 | 17 |
|---|---|
| 2009 | 31 |
| 2010 | 52 |
| 2011 | 44 |
| 2012 | 47 |
| 2013 | 43 |
| 2014 | 65 |
| 2015 | 82 |
| 2016 | 100 |
| 2017 | 83 |
| 2018 | 98 |
| 2019 | 83 |
| 2020 | 87 |
| 2021 | 95 |
| 2022 | 124 |
| 2023 | 152 |
| 2024 | 122 |
| 2025 | 120 |
| 2026 | 264 |
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\") = 2008
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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") = 2008 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA09CA101Accident · Minor injuriesData collectionFinal reportSteven G Goonen Searey · Polkland, FLA loss of control during the initial climb for undetermined reasons.NTSB ERA09WA113Accident · 12 fatalForeign investigationBritten Norman BN-2A MK III · Turks and Caicos, Turks & Caicos IslandsNTSB CEN09IA057Incident · No injuriesIncident investigationFinal reportCessna T210N · Lubbock, TXAn unidentified anomaly within the airplane's electrical system. Contributing to the incident was the pilot's failure to manually extend the landing gear.NTSB ERA09WA037Accident · 3 fatalForeign investigationBeech 65A90 · Timehri, GuyanaNTSB ERA09WA028Accident · 1 fatalClass 5 · ForeignHawker-Beechcraft 100 · Bauru, BrazilNTSB NYC08WA308Accident · 2 fatalForeign investigationRobinson R-44 · Muzino Village, RussiaNTSB DFW08LA220Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20B · Cleburne, TXLoss of control inflight for undetermined reason.NTSB DFW08WA240Accident · 1 fatalForeign investigationCessna 501 · Las Americas, Dominican RepublicNTSB CHI08FA248Accident · 1 fatalField investigationFinal reportBeech 58TC · Marysville, OHThe pilot's failure to maintain sufficient airspeed during the base to final turn resulting in an aerodynamic stall.NTSB DCA08WA086AccidentForeign investigationBoeing 767 - 200 · Budapest, HungaryOn July 29, 2008, at 1607 local Budapest time, a Krasnojarsky Airlines Boeing 767-200, EI-GBA, experienced an inadvertent deployment of an emergency escape slide after takeoff from Budapest, Hungary. The flight continued to its destination of Domodedovo…NTSB DEN08LA127Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Ventus A · Midlothian, TXThe pilot's inability to maintain aircraft control due to an incapacitating cardiac event. Contributing to the accident was the pilot's poor decision to fly with known serious medical issues.NTSB NYC08FA238Accident · 1 fatalField investigationFinal reportCessna 152 · Rossville, TNUndetermined.NTSB DCA08WA074AccidentForeign investigationFairchild SA226 · Bergen, NorwayOn June 20, 2008, at 1032 local Norwegian time, a Helitrans AS Fairchild Aircraft Corporation SA226-T(B), registration LN-SFT, crashing into the North Sea approximately 15 NM West of Bergen Airport (ENBR), Bergen, Norway. The aircraft was on a training flight…NTSB DCA08WA073Accident · 4 fatalForeign investigationCessna 210 · Nairegi Enkera, KenyaOn June 10, 2008, about 1200 UTC, a Cessna 210, registration 5Y-BE, a chartered flight, was en route when it collided with high terrain near Nairegi Enkera, Kenya. The airplane was on a visual flight; instrument meteorological conditions prevailed due to low…NTSB DFW08FA111Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Hemphill, TXA loss of control for undetermined reasons.NTSB CHI08CA088Accident · No injuriesData collectionFinal reportShaffer KR-2 · Fremont, OHThe loss of engine power for undetermined reasons during takeoff.NTSB CHI08FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 310N · Keflavík, IcelandThe reported loss of both engines' power during cruise for undetermined reasons.