NTSB investigations, NC
13 cases where the first occurrence was “Fire”.
Cases per year
| 1982 | 3 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1995 | 2 |
| 1997 | 1 |
| 2002 | 1 |
| 2006 | 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\" = 'NC' 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" = 'NC' 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 ATL06IA071Incident · No injuriesIncident investigationFinal reportBeech C90A · Raleigh, NCThe inadequate manufacturing process, which resulted in a windshield fire and subsequent emergency landing.NTSB ATL06IA054Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Asheville, NCThe improper installation of the pilot's windshield by company maintenance personnel, which resulted in flame and smoke in the cockpit, and subsequent emergency landing.NTSB MIA02LA118Accident · No injuriesLimited investigationFinal reportCessna 150D · Louisburg, NCthe failure of the pilot-in-command to follow emergency procedures after smelling smoke that resulted in an electrical fire, damage to the airplane, and a forced landing.NTSB MIA98LA028Accident · No injuriesLimited investigationFinal reportCessna 182A · Parkton, NCimproper installation of an auto battery cable which led to an in-flight fire due to the chaffed cable.NTSB ATL95LA109Accident · No injuriesLimited investigationFinal reportCessna 188 · Red Springs, NCInadequate maintenance that overlooked corrosion of the exhaust manifold, which resulted in an exhaust manifold leak, an in flight fire, and a complete loss of engine power.NTSB ATL95FA099Accident · 2 fatalField investigationFinal reportSchlagenhauf Lancair IV · Gastonia, NCAn in-flight fire of undetermined origin that resulted in a loss of control and impact with the ground.NTSB ATL89LA087Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Huntersville, NCFire resulting from an oil leak of undetermined origin in the area of the left engine.NTSB ATL87MA057Accident · 4 fatalMajor investigationFinal reportBell 206L-1 · Pollockville, NCThe emerg med svc (ems/med-evac) helicopter (hel) was on a ngt flt with a 3 month old patient aboard. After rprtg lvl AT3000', the plt transmitted he was going to make an emerg lndg. This was flwd by svrl unreadable transmissions which apchctl psnl thought…NTSB ATL86LA052Accident · No injuriesLimited investigationFinal reportCessna 150M · Whiteville, NCThe student plt had moved the aircraft closer to the terminal about 15 minutes prior to this attempted start. He tried several times but it would not start. The plt then primed the eng several times. His wife shouted to him that the aircraft was on fire. His…NTSB ATL85LA087Accident · No injuriesLimited investigationFinal reportBeech B-80 · Newbern, NCPilot experienced left engine fire at cruise. Emergency procedures completed, extinguishing the fire. Left nacelle sustained substantial damage, preventing determination of fire orgin.NTSB ATL83IA028Incident · No injuriesIncident investigationFinal reportConvair 340 · Greenboro, NCThe pilot stated that while at cruise at 4000 feet that there was a sharp jolt in the airframe and on further investigation discovered that the left engine was on fire. The propeller stopped turning shortly thereafter. Immediately the pilot pulled the…NTSB ATL82FA229Accident · Serious injuriesField investigationFinal reportPiper PA-32-260 · Raleigh, NCShortly after takeoff the acft caught fire. The plt attempted to turn back to the arpt but the eng lost power & the acftcould not maintain altitude. The acft crashed into a heavily wooded state park. The #5 cylinder exhaust pipe was found separated & was not…NTSB ATL82IA159Incident · No injuriesIncident investigationFinal reportPiper PA-31-325 · Asheboro, NCDuring cruise at 5000 ft the pilot smelled electrical fumes and noticed smoke filling the flap indicator gauge. He pulled the wing flap circuit breaker but moments later volumes of smoke arose from under the instrument panel, with flames observed behind the…