NTSB investigations, NM
11 cases where the first occurrence was “Fire”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1992 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2007 | 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\" = 'NM' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 171)
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" = 'NM' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 171) 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 DEN07LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Taos, NMThe unsecured B-nut fitting to the fuel return line which allowed for fuel spillage, an engine fire, and fuel exhaustion that led to the engine's subsequent failure. a factor contributing to the accident was the pilot's intentional wheels up landing in rough,…NTSB DEN07LA148Accident · 2 fatalLimited investigationFinal reportElliott Cirrus VK30 · Watrous, NMThe pilot's failure to maintain control of the airplane during a forced landing that resulted in a hard landing. Contributing to the accident was the ruptured pressurized oil line.NTSB FTW02LA098Accident · Serious injuriesLimited investigationFinal reportRepublic P-47N-20-RE · Albuquerque, NMthe pilot/mechanic's failure to properly re-install the engine's #10 cylinder exhaust interconnect tube, which resulted in an in-flight fire and forced landing. Contributing factors were the burned fuel and oil supply lines, which were not fire shielded.NTSB DEN01LA077Accident · No injuriesLimited investigationFinal reportBell UH-1H · Zuni, NMa hard landing due to the pilot's failure to maintain aircraft control during autorotation/flare. A factor was the total loss of engine power due to mechanical failure.NTSB FTW92DQA02Accident · Serious injuriesFinal reportFantasy Sky Promotions AX-7 · Rio Rancho, NMThe pilot's improper inspection of the balloon following removal of two of the fuel tanks which resulted in vented fuel due to a fuel line being left loose and a fuel valve locked open.NTSB FTW92GA111Accident · 1 fatalFinal reportPiper PA-32R-301T · Albuquerque, NMFuel line failure due to vibratory fatigue. Factors were improper maintenance, manufacturer information for fuel line not available, and the pilots' failure to follow emergency procedures.NTSB DEN88LA127Accident · No injuriesLimited investigationFinal reportCessna 182K · Cotton City, NMThe pilot reported that he was attempting to start the Cessna 182 for a cross country, solo, personal transportation flight. During the starting procedures, the engine backfired and the pilot smelled and saw smoke coming from the engine cowling area. The…NTSB DEN88LA004Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7-B · Rio Rancho, NMThe plt rptd that she had vented the Balloon to land. She said it takes both of her hands to open the vent and hold it open. 'When the Balloon hit the ground the burner went on by itself, wide open. The envelope was swinging from the contact of the basket…NTSB FTW83LA418Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Belen, NMThe student & instructor plt (CFI) had flown the acft from albuquerque to Belen, NM, & had shut down the eng. During an eng start to continue the flt about 20 min later, a fire started in the eng & the acft was destroyed by fire. The source of the fire was…NTSB FTW83FA001Accident · 4 fatalField investigationFinal reportThunder Balloons AX9-140 · Albuquerque, NMAfter what was described as a normal landing liquid propane began escaping. The propane vaporized & was ignited engulfing the gondola in flames. Four pax exited the gondola while it was still on the ground & the last survivor exitedat about 25 ft as the…NTSB FTW82FA109Accident · 2 fatalField investigationFinal reportBeech B35 · Dulce, NMApproximately 30 min after departure the acft returned to the arpt trailing smoke & occassional flame from an area near the cowl flaps & nose gear doors. The plt did not make a straight in approach but appeared to be in a normal traffic pattern. The acft…