Skip to content

NTSB investigations, 2010

22 cases where the defining event was Fire/smoke (non-impact).

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Where

Latest cases

Query with SQL

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") = 2010 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

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\") = 2010
    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 year(c."eventDate") = 2010
  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 ERA11IA091Incident · No injuriesIncident investigationFinal reportEurocopter Deutschland MBB-BK 117 C-1 · Boston, MAImproper installation of wiring associated with a medical cabinet interior, which resulted in chafing and a subsequent in-flight fire. Contributing to the incident was inadequate maintenance procedures for continued airworthiness.Dec 4, 2010 · N271NE · Minor damage NTSB DCA11WA031Incident · No injuriesForeign investigationBoeing 747 · Frankfurt, GermanyOn November 9, 2010, a Boeing 747-400, German registration D-ABVT, operated by Lufthansa, experienced a fire in the APU compartment. There were no injuries, and minor damage to the airplane. This incident is being investigated by the BFU of Germany.…Nov 9, 2010 · D-ABVT · Minor damage NTSB CEN10LA572Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Tulsa, OKA shorted terminal lug on the landing gear hydraulic pump which resulted in a cabin fire. Contributing to the accident was the lack of clear installation procedures for the hydraulic pump.Sep 28, 2010 · N5145U · Destroyed NTSB DCA10RA092Accident · 2 fatalClass 5 · ForeignBoeing 747-44AF · Dubai, United Arab EmiratesSep 3, 2010 · N571UP · Destroyed NTSB DCA10IA082Incident · Minor injuriesIncident investigationFinal reportBoeing 767-322 · Chicago, ILthe brake fire after landing was caused by hydraulic fluid leaking on to hot brakes.Aug 4, 2010 · N644UA · Minor damage NTSB ERA10LA387Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33AK · Windsor, VAThe unauthorized installation of a battery and associated wiring and electrical components, which resulted in an in-flight electrical fire of undetermined origin.Jul 30, 2010 · N17965 · Substantial damage 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…Jul 30, 2010 · N96LN · Substantial damage NTSB ENG10IA041Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-88 · Atlanta, GAThe cause of the right wing landing light switch fire is undetermined.Jul 18, 2010 · N990DL · Minor damage NTSB ERA10WA371Accident · 1 fatalForeign investigationRobinson R44 · Novo Horizonte, BrazilOn July 16, 2010, about 1645 Universal Coordinated Time (UTC), a Robinson R-44 helicopter, Brazilian registration PR-TNB, operated by Pereira Alvim Participacoes e Empreendimentos Ltda, was destroyed by fire after landing in a cane field at Novo Horizonte,…Jul 16, 2010 · PR-TNB · Destroyed NTSB WPR10LA319Accident · No injuriesLimited investigationFinal reportPridmore Lancair IV · Caldwell, IDThe failure of maintenance personnel to ensure that a hydraulic line fitting was adequately secured during a conditional inspection, which resulted in a leak and subsequent on-ground fire.Jun 28, 2010 · N86PB · Substantial damage NTSB WPR10LA308Accident · No injuriesLimited investigationFinal reportHughes 369HS · Paicines, CAAn in-flight fire for undetermined reasons.Jun 22, 2010 · N8305F · Substantial damage NTSB ENG10IA038Incident · No injuriesIncident investigationFinal reportBoeing 767 · Athens, GreeceA short circuit involving the light in position L3 on the squib test panel. The specific cause of the short circuit could not be determined.Jun 16, 2010 · N196DN · Minor damage NTSB CEN10LA287Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Wellington, KSA fire of undetermined cause that originated in the airplane's cabin.Jun 1, 2010 · N1821P · Destroyed NTSB WPR10FA264Accident · Serious injuriesField investigationFinal reportPiper PA-28-161 · Chandler, AZFailure of the maintenance personnel to ensure adequate torque of a fuel line fitting, which resulted in an in-flight fire.May 26, 2010 · N4122T · Substantial damage NTSB ENG10IA029Incident · No injuriesIncident investigationFinal reportBoeing 757 · Chantilly, VAThe ignition of the J5 power terminal located on the captain’s No. 1 windshield due to a loose electrical connection between the terminal connector lug and its respective terminal block. The loose connection resulted from a missing lock washer that allowed…May 17, 2010 · N510UA · Minor damage NTSB ERA10LA210Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Pittsburgh, PAA fire of undetermined origin behind the left instrument panel.Apr 5, 2010 · N156J · Substantial damage NTSB CEN10LA186Accident · No injuriesLimited investigationFinal reportCessna 182F · Wichita Falls, TXA fire of undetermined origin.Apr 1, 2010 · N3320U · Substantial damage NTSB DCA10WA041Incident · No injuriesForeign investigationBoeing 747 · Paris, FranceOn March 18, 2010, at 0700 local time (0600 UTC), a Thai Airways International Boeing 747-4D7, registered in Thailand as HS-TGL, experienced a fire in its avionics bay while parked at Charles de Gaulle International Airport (CDG), Paris, France. No injuries…Mar 18, 2010 · HS-TGL · Minor damage NTSB ERA10IA147Incident · No injuriesIncident investigationFinal reportPiper PA-46-310P · Nashville, TNA loss of engine power due to the mechanic’s failure to properly secure the fuel control unit fuel lines after replacement of the starter adapter.Feb 21, 2010 · N43368 · Minor damage NTSB CEN10CA111Accident · No injuriesData collectionFinal reportPiper PA-32R-301T · Reserve, NMAn in-flight fire due to a fuel leak from the No. 5 cylinder's broken fuel injector/line.Feb 1, 2010 · N3565B · Substantial damage NTSB ENG10IA010Incident · No injuriesIncident investigationFinal reportATR ATR72 · St. CroixThe sealing failure between the fuel nozzle adapter assembly and fuel transfer tubes that allowed fuel to leak into the nacelle fire zone where it was subsequently ignited by the hot combustor case. Contributing to the failure was a combination of…Jan 12, 2010 · N434AT · Minor damage NTSB DCA10WA019Incident · Minor injuriesForeign investigationBoeing 737 · Hahn, GermanyOn January 4, 2010, at 0940 UTC, a Boeing 737-800, Irish registration EI-DAK, operated by Ryan Air, experienced fire and smoke in a ground power unit connector prior to takeoff at Hahn, Germany. The aircraft had minor damage and 5 of the 6 crew members…Jan 4, 2010 · EI-DAK · Minor damage