NTSB investigations, 2008, GA
8 cases where the sequence of events included Off-field or emergency landing.
Cases per year
| 2008 | 8 |
|---|---|
| 2009 | 10 |
| 2010 | 11 |
| 2011 | 10 |
| 2012 | 9 |
| 2013 | 4 |
| 2014 | 5 |
| 2015 | 7 |
| 2016 | 7 |
| 2017 | 5 |
| 2018 | 4 |
| 2019 | 2 |
| 2020 | 5 |
| 2021 | 5 |
| 2022 | 9 |
| 2023 | 4 |
| 2024 | 3 |
| 2025 | 1 |
| 2026 | 5 |
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.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '440' 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."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '440' 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 ERA09FA005Accident · Minor injuriesField investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Swainsboro, GAA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.NTSB ERA09LA004Accident · No injuriesLimited investigationFinal reportCessna T210M · Savannah, GAA loss of engine power in flight due to fuel exhaustion as a result of the pilot's improper fuel management.NTSB MIA08LA196Accident · No injuriesLimited investigationFinal reportCessna 120 · Jesup, GAAn oil starvation-induced catastrophic engine failure due to the improper installation of the crankshaft expansion plug during engine overhaul.NTSB MIA08LA156Accident · Minor injuriesLimited investigationFinal reportDiamond DA-20-C1 · Peachtree City, GAA partial loss of engine power for undetermined reasons.NTSB NYC08LA245Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Pelham, GAA partial loss of engine power for undetermined reasons which led to a forced landing in unsuitable terrain.NTSB MIA08LA133Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Colquitt, GALoss of engine power due to the installation of incorrect turbine blades on the compressor turbine disk during repair of the disk assembly.NTSB MIA08LA101Accident · No injuriesLimited investigationFinal reportHigher Class Sport Hornet · Appling, GAThe interruption of fuel flow for undetermined reasons, resulting in a loss of engine power during flight.NTSB NYC08CA132Accident · No injuriesData collectionFinal reportRotorway 162F · Cartersville, GAThe owner/builder's improper installation of the foot pedal scissor beam, which resulted in its failure during hover flight.