NTSB investigations, 2018, TX
16 cases where the sequence of events included Miscellaneous/other.
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 6 |
| 2010 | 7 |
| 2011 | 7 |
| 2012 | 11 |
| 2013 | 5 |
| 2014 | 3 |
| 2015 | 8 |
| 2016 | 7 |
| 2017 | 4 |
| 2018 | 16 |
| 2019 | 6 |
| 2020 | 7 |
| 2021 | 3 |
| 2022 | 3 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 2 |
| 2026 | 3 |
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\") = 2018
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\" = '900' 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") = 2018 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" = '900' 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 GAA19CA129Accident · No injuriesData collectionFinal reportCessna 182 · Marshall, TXThe pilot's failure to maintain directional control during landing.NTSB CEN19LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Abilene, TXThe pilot's failure to see and avoid a cell tower wire during a pipeline patrol flight. Contributing to the accident was the pilot's distraction due to writing down observations about the pipeline while flying.NTSB GAA19CA011Accident · Minor injuriesData collectionFinal reportBeech 55 · San Antonio, TXThe pilot's improper takeoff trim setting and failure to properly secure his seatbelt, which resulted in a loss of airplane control. Contributing to the accident was the pilot's failure to follow the Before Takeoff checklist.NTSB GAA18CA464Accident · No injuriesData collectionFinal reportCessna 172 · Spring, TXThe student pilot’s improper landing flare in a crosswind, which resulted in a hard landing.NTSB CEN18LA287Accident · No injuriesLimited investigationFinal reportCessna 210C · Blum, TXThe pilot's excessive leaning of the fuel mixture, which resulted in a loss of engine power, and the pilot's failure to extend the landing gear in accordance with the airplane emergency checklist, which resulted in a gear-up landing.NTSB CEN18LA290Accident · Minor injuriesLimited investigationFinal reportBell 206 · Todd Mission, TXThe passenger’s inadvertent interference with the tail rotor pedals, which resulted in a loss of helicopter control during takeoff and the subsequent impact with terrain.NTSB GAA18CA393Accident · No injuriesData collectionFinal reportZenair Zenith Stol CH 701 · San Saba, TXThe pilot’s improper landing flare during the aborted takeoff, which resulted in a hard landing and a nose-over.NTSB CEN18LA250Accident · No injuriesLimited investigationFinal reportCessna 180 · Lago Vista, TXThe separation of the left main landing gear spring during landing due to a preexisting fatigue crack.NTSB CEN18CA240Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Encino, TXThe gunner's failure to ensure that the net would not ensnare the helicopter's skids once deployed, which resulted in the pilot being unable to maintain helicopter control as the bull pulled on the net and subsequent impact with terrain.NTSB CEN18CA294Accident · No injuriesData collectionFinal reportRobinson R22 · Sterling City, TXThe pilot’s improper decision to exit the helicopter without shutting down the engine, which allowed the collective/throttle to increase and resulted in a loss of control of the unattended helicopter.NTSB GAA18CA300Accident · No injuriesData collectionFinal reportCessna 150 · Killeen, TXThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a maximum performance takeoff, which resulted in an aerodynamic stall. Also causal was the pilot’s failure to use the appropriate flap…NTSB CEN18LA167Accident · Serious injuriesLimited investigationFinal reportEnstrom Helicopter 280C · Kerens, TXThe total loss of engine power due to fuel exhaustion and the pilot’s inadequate in-flight fuel management.NTSB GAA18CA264Accident · No injuriesData collectionFinal reportPiper PA28 · Addison, TXThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN18LA114Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Odessa, TXThe pilot’s improper takeoff procedures and his failure to abort the takeoff, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s lack of experience in the airplane.NTSB GAA18CA129Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 · Wadsworth, TXThe passenger’s gun becoming lodged in the flight controls during takeoff and his failure to remove it, which resulted in impact with terrain.NTSB CEN18LA084Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Abilene, TXMaintenance personnel’s improper maintenance of the engine, which resulted in a catastrophic engine failure due the shifting/slipping of the No. 2 bearing and the subsequent oil starvation and total loss of engine power during cruise flight.