NTSB investigations, 2019, TX
20 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\") = 2019
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") = 2019 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 CEN20LA051Accident · No injuriesClass 3 · LimitedFinal reportEnstrom F28 · Danbury, TXThe failure of the engine's No.3 intake valve resulting is a loss of engine power and a rollover following the autorotation to soft ground.NTSB CEN20LA020Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus SR22 · Tyler, TXA total loss of engine power as a result of detonation due to a combination of improper magneto to engine timing and a rich fuel mixture.NTSB CEN20LA018Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Houston, TXThe pilot's failure to select the proper fuel tank before departure, which resulted in fuel starvation and a total loss of engine power.NTSB CEN20LA016Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Springtown, TXA total loss of engine power for undetermined reasons.NTSB CEN19LA326Accident · No injuriesClass 3 · LimitedFinal reportVans Vans RV-10 · Lancaster, TXA partial loss of engine power due to a faulty magneto/ignition system, which resulting in a forced landing.NTSB CEN19LA316Accident · 1 fatalClass 3 · LimitedFinal reportInfinity Powered Parachutes IPP2 · Eustace, TXThe pilot’s failure to see and avoid a power line. Contributing was the pilot’s decision to fly at an altitude too low to avoid obstacles.NTSB CEN19LA299Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Conroe, TXA partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN19LA295Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT502 · Olney, TXA loss of thrust control due to a propeller surge event, which resulted in a forced landing shortly after takeoff.NTSB CEN19LA275Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Rio Grande City, TXThe loss of engine power following an increase in oil temperature for undetermined reasons during cruise flight, which resulted in a forced landing on unsuitable terrain.NTSB CEN19LA232Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Fredericksburg, TXA total loss of engine power for undetermined reasons.NTSB CEN19LA193Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R22 · Garwood, TXThe pilots' failure to maintain clearance from a power line during low level operations.NTSB CEN19LA187Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Danbury, TXA failed electrical relay, which provided an improper indication of a governor and clutch problem, which resulted in the pilot conducting a precautionary landing during which he failed to maintain sufficient main rotor speed.NTSB DCA19CA170Accident · No injuriesData collectionFinal reportBoeing CV2 · Beeville, TXA higher than expected and accounted for crosswind which initiated a lateral deviation, and resulted in the aircraft reaching the limits of the geo-fence area triggering a contingency forced landing.NTSB CEN19LA158Accident · Serious injuriesClass 3 · LimitedFinal reportBoeing B75N1 · Fredericksburg, TXThe loss of engine power for undetermined reasons.NTSB CEN19TA131Accident · No injuriesClass 3Final reportAir Tractor AT 602 · Quanah, TXThe pilot's failure to maintain clearance from the power line during a low altitude aerial application maneuver.NTSB CEN19LA129Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 23 · Sulphur Spring, TXThe pilot’s inadequate preflight inspection, during which he failed to detect the water contamination in the left fuel, which resulted in a partial loss of power in the left engine. Contributing to the accident was the total loss of power in the right engine…NTSB CEN19TA073Accident · Serious injuriesFinal reportBeech A36 · Fort Worth, TXThe pilot's improper fuel management, which resulted in fuel starvation and a loss of engine power.NTSB CEN19LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA32RT · Pflugerville, TXThe pilot's fuel mismanagement and his improper use and placement of the fuel selector, contrary to operating procedures, which resulted in a partial loss of engine power due to fuel starvation.NTSB CEN19LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Aguilares, TXThe loss of engine power due to fuel starvation.NTSB CEN19LA065Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Uvalde, TXThe slipping of the sprag clutch due to galling of the sprags and corresponding sprag contact surfaces within the clutch assembly, which rendered the helicopter uncontrollable.