NTSB investigations, 2014, TX
21 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\") = 2014
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") = 2014 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 CEN15CA067Accident · No injuriesData collectionFinal reportCessna 210 · Edinburg, TXThe loss of engine power due to fuel exhaustion, which resulted from the non-certificated pilot's inadequate preflight planning and inflight decision making.NTSB CEN15LA063Accident · Serious injuriesLimited investigationFinal reportSiegel Gerald Long EZ · McGregor, TXA loss of engine power during takeoff due to excessive debris in the fuel system.NTSB CEN15FA032Accident · 1 fatalField investigationFinal reportLangston, Frederick L RV 4 · Boerne, TXA total loss of engine power for reasons that could not be determined, because post accident examination did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation.NTSB CEN15LA038Accident · Minor injuriesLimited investigationFinal reportStol UC 1 · Jacksonville, TXThe loss of right engine power while climbing due to fuel starvation for reasons that could not be determined during postaccident airplane examination and testing, which led to a forced landing on hilly terrain.NTSB CEN15TA035Accident · No injuriesFinal reportBell UH1H · San Isidro, TXThe flight crew's failure to ensure that the sliding cabin door was properly secured before the flight.NTSB CEN15LA002Accident · Serious injuriesLimited investigationFinal reportBell 206B · Woodsboro, TXThe pilot’s failure to recognize and correct for flight conditions conducive to a loss of tail rotor effectiveness, which resulted in a rapid, uncommanded right yaw and subsequent hard landing.NTSB CEN14LA495Accident · No injuriesLimited investigationFinal reportNolin Vans RV-10 · Houston, TXThe total loss of engine power for reasons that could not be determined during postaccident examination.NTSB CEN14FA468Accident · 2 fatalField investigationFinal reportSchafer Rick W Foxtrot 4 · Abilene, TXThe pilot's decision to attempt a steep turn to return to the airport after reporting an emergency. The reason for the emergency could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical anomalies that…NTSB CEN14CA482Accident · No injuriesData collectionFinal reportBeech 95 B55 (T42A) · Bremond, TXMismanagement of fuel, which resulted in a total loss of power due to fuel starvation.NTSB CEN14LA385Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Wichita Falls, TXA partial loss of engine power, which resulted in a forced landing on unsuitable terrain. The reason for the loss of engine power could not be determined during postaccident examination.NTSB CEN14CA380Accident · No injuriesData collectionFinal reportDantonio 404 · Wichita Falls, TXThe separation of a spark plug wire resulting in a loss of engine power during climb out and a subsequent forced landing on a field containing trees.NTSB CEN14LA347Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Baytown, TXThe pilot’s failure to verify the fuel onboard before the flight, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN14LA331Accident · No injuriesLimited investigationFinal reportCessna A188 · Arlington, TXThe total loss of engine power due to a loose oil filter adapter, which resulted in oil starvation. Contributing to the accident was maintenance personnel’s failure to comply with a Federal Aviation Administration airworthiness directive.NTSB CEN14CA303Accident · Minor injuriesData collectionFinal reportPiper PA 28-180 · Port Isabel, TXA loss of engine power due to the pilot's improper inflight planning and reliance of fuel gauge readings, which resulted in fuel exhaustion.NTSB CEN14LA293Accident · No injuriesLimited investigationFinal reportKnauf RV-7 · Rockwall, TXThe pilot's failure to verify the airplane's actual fuel quantity before departure, which resulted in a total loss of engine power due to fuel exhaustion and the subsequent forced landing.NTSB CEN14LA287Accident · No injuriesLimited investigationFinal reportAir Tractor AT 301 · Pearsall, TXThe failure of the No. 1 cylinder rod at the link pin. Contributing to the accident was oil starvation to the rod bearing due to the improper flushing of the oil cooler, which allowed metal and other debris in the oil to clog the drain and the led to the…NTSB CEN14LA263Accident · No injuriesLimited investigationFinal reportAero Commander 200D · La Grange, TXThe loss of engine power due to oil starvation for reasons that could not be determined based on the available evidence.NTSB CEN14LA253Accident · No injuriesLimited investigationFinal reportBeech A36 · Rockdale, TXA loss of engine power for reasons that could not be determined because postaccident testing revealed no anomalies.NTSB CEN14CA227Accident · No injuriesData collectionFinal reportPiper PA 24-250 · New Braunfels, TXThe loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight planning and inflight decision making.NTSB CEN14LA226Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctls · Greenville, TXThe fatigue failure of the No. 4 cylinder exhaust valve due to excessive wear of the corresponding train tappet, which resulted in a total loss of engine power.NTSB CEN14LA118Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA 5B · Willow Park, TXThe improper reinstallation of the propeller assembly, which resulted in the subsequent in-flight separation of the propeller.