NTSB investigations, 2020, 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\") = 2020
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") = 2020 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 CEN21LA103Accident · No injuriesClass 3 · LimitedFinal reportCessna 172H · Cypress, TXA total loss of engine power due to fuel exhaustion.NTSB CEN21LA092Accident · 1 fatalClass 3 · LimitedFinal reportSonex Tailwheel · Burleson, TXA total loss of engine power due to engine seizure. Contributing to the accident was the pilot decision not to orbit the airport, as originally planned.NTSB CEN21LA031Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Buda, TXAn improperly torqued oil line fitting during an engine overhaul, which resulted in oil exhaustion and a total loss of engine power.NTSB CEN20LA420Accident · No injuriesClass 3 · LimitedFinal reportBeech V35 · Terrell, TXFuel starvation due to a fuel system leak, which resulted in a loss of engine power and the subsequent forced landing on unsuitable terrain.NTSB CEN20LA384Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32R · Bonham, TXThe loss of engine power due to a disconnected fuel injector line that was not properly tightened during recent maintenance.NTSB CEN20LA380Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35 · Canyon Lake, TXThe total loss of engine power for a reason that could not be determined based on available information.NTSB CEN20LA291Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Arlington, TXThe pilot's failure to maintain directional control during a forced landing with a quartering tailwind, following a partial loss of engine power due to carburetor icing.NTSB CEN20LA279Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT502 · Dalhart, TXThe total loss of engine power due to a failed fuel control unit bearing.NTSB CEN20LA258Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Bridgeport, TXMaintenance personnel’s inadequate inspection, which resulted in a total loss of engine power due to a restricted air intake-induction system.NTSB CEN20LA256Accident · 1 fatalClass 3 · LimitedFinal reportCessna 320 · Round Rock, TXImproper maintenance that led to a loss of engine power due to a failed left engine magneto, the pilot’s improper application of single engine emergency procedures, and his failure to maintain control of the airplane which resulted in a collision with trees.NTSB CEN20LA245Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182 · Winfield, TXThe total loss of engine power due to the pilot’s improper fuel management, which led to fuel starvation. Contributing to the accident was the low altitude at which the loss of engine power occurred.NTSB CEN20LA211Accident · No injuriesClass 3 · LimitedFinal reportBeech 23 · Cleburne, TXThe total loss of engine power due to metal fatigue failure of the No. 1 cylinder wall.NTSB CEN20LA162Accident · Minor injuriesClass 2 · LimitedFinal reportCessna T210 · New Braunfels, TXThe pilot's inadequate preflight inspection and fuel planning, which resulted in the loss of engine power due to fuel exhaustion.NTSB CEN20LA159Accident · Serious injuriesClass 3 · LimitedFinal reportPilatus PC12 · Mesquite, TXThe loss of engine power due to a mis-rigged beta control cable (propeller reversing cable), which resulted in a loss of thrust inflight.NTSB CEN20CA146Accident · Minor injuriesData collectionFinal reportPitts S2 · Fort Worth, TXThe pilot's inadequate preflight inspection of the fuel level, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN20CA144Accident · No injuriesData collectionFinal reportRobinson R22 · Seymour, TXThe pilot's failure to maintain clearance from a tree while maneuvering at low altitude.NTSB CEN20LA140Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Seguin, TXThe pilot’s mismanagement of airspeed and glidepath during approach for a precautionary landing, which resulted in a runway excursion and a collision with a fence.NTSB CEN20CA129Accident · No injuriesData collectionFinal reportPiper PA18 · Canyon, TXThe pilot's selection of unsuitable terrain for landing, which resulted in a collision with a ditch and the left main landing gear collapsing.NTSB CEN20LA082Accident · No injuriesClass 3 · LimitedFinal reportCessna 560 · Aledo, TXThe in-flight separation of the upper and lower right engine cowlings for reasons that could not be determined based on available evidence.NTSB CEN20TA071Accident · Minor injuriesClass 3Final reportBeech 60 · Big Spring, TXA total loss of engine power in both engines due to fuel exhaustion, which resulted in a landing short of the runway.NTSB CEN20LA055Accident · No injuriesClass 3 · LimitedFinal reportAero Commander 100 · Mullin, TXA total loss of engine power for reasons that could not be determined based on the available information.