NTSB investigations, 2008, TX
14 cases where the sequence of events included Off-field or emergency landing.
Cases per year
| 2008 | 14 |
|---|---|
| 2009 | 17 |
| 2010 | 19 |
| 2011 | 21 |
| 2012 | 15 |
| 2013 | 15 |
| 2014 | 21 |
| 2015 | 16 |
| 2016 | 19 |
| 2017 | 11 |
| 2018 | 25 |
| 2019 | 20 |
| 2020 | 21 |
| 2021 | 11 |
| 2022 | 13 |
| 2023 | 11 |
| 2024 | 15 |
| 2025 | 14 |
| 2026 | 5 |
Where
Latest 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\" = 'TX' 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" = 'TX' 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 CEN09IA096Incident · No injuriesIncident investigationFinal reportCessna 182 · Fort Worth, TXCollision with a hidden obstruction while taxiing through a grass field following a forced landing. Contributing to the accident was a loss of engine power due to the pilot's failure to turn on the carburetor heat.NTSB CEN09LA055Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Nacogdoches, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CEN09LA024Accident · No injuriesLimited investigationFinal reportCessna A185F · Angleton, TXThe loss of engine power for undetermined reasons. Contributing to the accident was the lack of suitable terrain for the pilot to execute the forced landing.NTSB CEN09LA014Accident · No injuriesLimited investigationFinal reportBeech A36 · Houston, TXThe total loss of engine power due to a fracture in the oil filter adapter housing. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB DEN08LA158Accident · Serious injuriesLimited investigationFinal reportCameron Balloons US N-77 · Plano, TXThe pilot's improper fuel management, resulting in fuel exhaustion and the subsequent hard landing.NTSB DFW08LA226Accident · Serious injuriesLimited investigationFinal reportCessna 182D · Orange Grove, TXA total loss of engine power due to an improperly installed intake manifold tube.NTSB DFW08CA211Accident · No injuriesData collectionFinal reportMurray Frank H DA5B · Odessa, TXFailure of the intake manifold when the flexible connectors disconnected from the carburetor after a turbulence encounter. Contributing to the accident was insuitable terrain for a forced landing.NTSB DFW08LA210Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Caldwell, TXA loss of engine power in flight due to fuel exhaustion as a result of the pilot's failure to secure the right wing's fuel cap, leading to fuel being siphoned from the tank during flight.NTSB DFW08CA198Accident · No injuriesData collectionFinal reportRobinson R22 · Rosharon, TXThe pilot's failure to maintain terrain clearance while maneuvering. Contributing to the accident was the low altitude.NTSB DFW08CA192Accident · No injuriesData collectionFinal reportGrumman G-164A · Bovina, TXLoss of engine power for undetermined reasons.NTSB DFW08CA184Accident · No injuriesData collectionFinal reportWright Avid Flyer MK IV · Lake Jackson, TXThe loss of engine power due to a connecting rod failure.NTSB DFW08CA183Accident · No injuriesData collectionFinal reportGrumman American AA-5A · Denton, TXThe pilot's inadequate fuel management, which resulted in fuel starvation and the subsequent loss of engine power.NTSB DEN08LA105Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301A · Garwood, TXA loss of engine power due to the total failure of the number 2 cylinder.NTSB DFW08LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Spring, TXFailure of the pilot to ensure that the fuel system was purged of water prior to flight. Contributing to the severity of injuries was the lack of shoulder restraints.