NTSB investigations, TX
18 cases where the defining event was Fire/smoke (non-impact).
Cases per year
| 2009 | 2 |
|---|---|
| 2010 | 2 |
| 2011 | 3 |
| 2013 | 3 |
| 2017 | 1 |
| 2018 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2024 | 1 |
| 2025 | 2 |
Where
Open the mapLatest 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 c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '150')
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 c."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '150') 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 CEN25LA352Accident · Minor injuriesClass 4 · LimitedFinal reportGlasair GlaStar · Hearne, TXThe inflight engine compartment fire for reasons that could not be determined.NTSB CEN25LA205Accident · No injuriesClass 3 · LimitedPreliminary reportLancair 360 · Fort Stockton, TXOn June 11, 2025, about 2145 central daylight time, a Lancair 360 airplane, N77LH, was destroyed when it was involved in an accident near Fort Stockton, Texas. The airline transport pilot was not injured. The airplane was operated as a Title 14 Code of…NTSB CEN24LA147Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 7KCAB · Bluff Dale, TXAn engine compartment fire for reasons that could not be determined due to extensive thermal damage.NTSB CEN21LA211Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-161 · Spring, TXAn engine fire that resulted from a fuel leak into the carburetor air box due to the electric fuel pump over-pressurizing the carburetor needle/seat assembly. Contributing to the severity of the fire was the flight instructor’s failure to turn off the…NTSB CEN20LA058Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Bandera, TXThe in-flight electrical fire, which resulted in smoke in the cabin and an emergency landing. Contributing to the accident was the unsuitable terrain for the emergency landing.NTSB CEN18LA272Accident · No injuriesLimited investigationFinal reportCessna 182 · Odessa, TXAn on-ground fire for reasons that could not be determined based on the available information.NTSB CEN18FA139Accident · 1 fatalField investigationFinal reportWittman W10 · San Antonio, TXAn in-flight fire and subsequent total loss of engine power for reasons that could not be determined due to extensive impact and fire damage, followed by a loss of airplane control.NTSB CEN17LA151Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164A · Nome, TXAn in-flight fire for reasons that could not be determined based on available information.NTSB CEN14LA021Accident · No injuriesLimited investigationFinal reportPohoski RV 4 · New Waverly, TXAn in-flight fire for reasons that could not be determined because the wreckage was consumed by fire.NTSB CEN13LA408Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Houston, TXThe pilot’s failure to use the proper taxi procedure, which resulted in a brake system fire.NTSB ENG13IA016Incident · No injuriesIncident investigationFinal reportBoeing 747 · Dallas, TXFuel leaking from a fractured fuel manifold feeder line that ignited on contact with the engine’s hot compressor rear frame, which resulted in an engine undercowl fire. The fuel manifold feeder line failed due to high amplitude fatigue because the fuel…NTSB CEN11LA504Accident · No injuriesLimited investigationFinal reportQuasar Acft 214SL · Fort Worth, TXA fuel leak in the engine compartment, which resulted in an engine fire.NTSB CEN11LA327Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Chico, TXThe mechanic's improper installation of the turbocharger's exhaust balance system, which resulted in an in-flight fire.NTSB CEN11FA324Accident · 2 fatalField investigationFinal reportWoodward Harold L Ravin 500 · Conroe, TXAn in-flight smoke event on takeoff and the pilot’s failure to maintain control of the airplane, which resulted in an aerodynamic stall.NTSB CEN10CA456Accident · No injuriesData collectionFinal reportLindstrand 69A · Longview, TXThe the pilot's inadvertent movement of the burner assembly off center resulting in an in-flight fire of the skirt and envelope of the balloon. Contributing to the accident was the pilot's attention being diverted to venting the envelope to avoid an obstacle…NTSB CEN10LA186Accident · No injuriesLimited investigationFinal reportCessna 182F · Wichita Falls, TXA fire of undetermined origin.NTSB CEN09LA324Accident · Serious injuriesLimited investigationFinal reportBell 47G · Kyle, TXThe ground crewmember's failure to assure that the fuel nozzle was closed before pressurizing the line. Contributing to the accident was the lack of an available fire extinguisher.NTSB CEN09IA294Incident · Minor injuriesIncident investigationFinal reportBoeing 737 · Houston, TXThe pilot's inadvertent application of excessive braking after touchdown, which caused the right wheels to lock and several tires to blow and resulted in a subsequent brake fire.