Skip to content

NTSB investigations, 2013

23 cases where the sequence of events included 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") = 2013 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '150' 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

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\") = 2013
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '150' 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") = 2013
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '150' 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 WPR14LA049Accident · Serious injuriesLimited investigationFinal reportFirefly Balloons Firefly 10 · Temecula, CAThe pilot's failure to follow the Landing checklist and his inadvertent contact with the blast valve after landing, which released propane that was then ignited by an undetermined source.Nov 9, 2013 · N1623L · No damage NTSB ENG14WA003Incident · No injuriesForeign investigationBAE Systems Limit Avro 146-RJ85 · Norwich, Norfolk, UK, United KingdomOn October 24, 2013, a British Aerospace (BAE) 146 experienced an engine fire during a power check at Norwich International Airport (NWI), Norwich, Norfolk, UK. After receiving the fire warning maintenance crews successfully shut down the engine and…Oct 24, 2013 · WITHHELD · Minor damage NTSB DCA14WA005Incident · No injuriesForeign investigationBoeing 757 223 · Providenciales, Turks & Caicos IslandsThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving a Boeing 757, which occurred on October 22, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…Oct 22, 2013 · N605AA · No damage 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.Oct 19, 2013 · N10XP · Destroyed NTSB WPR14LA014Accident · No injuriesLimited investigationFinal reportBell Helicopter Textron 206L 1 · Seeley, CAThe total loss of engine power due to the failure of the No. 4 bearing.Oct 11, 2013 · N206KK · Destroyed NTSB CEN13LA561Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Ulysses, KSAn in-flight fire and subsequent loss of engine power for reasons that could not be determined due to extensive fire damage to the airplane and its fuel and electrical systems.Sep 25, 2013 · N4623M · Destroyed NTSB DCA13WA158Incident · No injuriesForeign investigationBoeing 757 223 · San Andreas, ColombiaThe CAA of Colombia has notified the NTSB of an incident involving a Boeing 757-223 airplane that occurred on September 19, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the CAA of Colombia's investigation under the provisions of…Sep 19, 2013 · N676AN · No damage NTSB WPR13LA432Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. AA 1C · Hemet, CAThe airplane’s hard landing due to the pilot’s failure to maintain sufficient airspeed while on approach after shutting down the engine because of the smoke in the cockpit from a burnt wire that originated from the alternator field terminal and extended to…Sep 9, 2013 · N9923U · Substantial damage NTSB DCA13WA143Incident · No injuriesForeign investigationBoeing 757 · Gatwick, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving a Boeing 757-2Y0, which occurred on August 23, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation…Aug 23, 2013 · G-FCLK · No damage NTSB CEN13LA490Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D1 · Eastport, MIA fuel leak in the engine compartment and subsequent fire, the source of which could not be determined because of extensive postaccident fire damage.Aug 14, 2013 · N44351 · Destroyed NTSB ENG13WA040Incident · No injuriesForeign investigationSikorsky S76 - A · Macae, BrazilWhile the helicopter was running on the runway, the pilots noticed that the number two engine parameters were below prescribed values and decided to abort the take-off. After leaving the runway and entering the company apron, the pilots saw company mechanics…Aug 7, 2013 · PT-YSM · Minor damage NTSB CEN13WA577Incident · No injuriesForeign investigationCessna Cessna 525B · Paris, FranceOn July 22, 2013, at 0610 UTC, a Cessna 525B Citation CJ3, French registration F-HCIC, experienced smoke in the cabin and cockpit while passing FL 140 during an enroute climb southeast of Paris, France. The number one engine was shut down, the crew declared…Jul 22, 2013 · F-HCIC · Minor damage NTSB DCA13RA127Accident · No injuriesForeign investigationBoeing 787 · London, United KingdomThe UK Air Accidents Investigation Branch (AAIB) has notified the NTSB of an accident involving a B787 that occurred on July 7, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions of ICAO Annex…Jul 12, 2013 · ET-AOP · Substantial damage 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.Jul 10, 2013 · N56FT · Substantial damage NTSB WPR13FA294Accident · 1 fatalField investigationFinal reportCessna 172 · Birdseye, UT***This report was modified on August 18, 2015. Please see the docket for this accident to view the original report.*** The operator's improper installation of a supplemental electrical power supply, which caused a short circuit due to inadequate vibration…Jun 27, 2013 · N4459R · Substantial damage NTSB CEN13LA365Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Lansing, MIThe pilot’s failure to follow the airplane checklist, which resulted in the parking brake not being released before taxi and a subsequent brake fire.Jun 19, 2013 · N4296T · Substantial damage NTSB DCA13WA104Incident · No injuriesForeign investigationBoeing 747-400 · London, United KingdomThe United Kingdom's Air Accidents Investigations Branch (AAIB), has notified the NTSB of an incident involving a Boeing 747-400 that occurred on June 9, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…Jun 9, 2013 · G-CIVA NTSB CEN13WA307Accident · 1 fatalForeign investigationPiper PA-28RT-201T · Tallard, FranceMay 29, 2013 · N68XM · Destroyed NTSB WPR13IA144Incident · No injuriesIncident investigationFinal reportBombardier DHC-8-402 · Danville, CAThe failure and separation of a section of the No. 2 engine's combustion chamber's small exit duct (SED), which created an airflow disruption that led to an engine surge and subsequent fire. Contributing to the accident was the insufficient weld penetration…Mar 5, 2013 · N417QX · Minor damage NTSB DCA13WA113Incident · No injuriesForeign investigationBoeing 737-300 · London, United KingdomThe United Kingdom's Air Accidents Investigations Branch (AAIB), has notified the NTSB of an incident involving a Boeing 737-300 that occurred on March 1, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…Mar 1, 2013 · G-CELS 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…Feb 25, 2013 · B18701 · Minor damage NTSB WPR13LA122Accident · Serious injuriesLimited investigationFinal reportST Clair Lancair 360 · Williams, CAAn in-flight fire due to an electrical short circuit.Feb 12, 2013 · N123ST · Destroyed NTSB DCA13IA037Incident · No injuriesClass 1 · IncidentFinal reportBoeing 787 · Boston, MAan internal short circuit within a cell of the auxiliary power unit (APU) lithium-ion battery, which led to thermal runaway that cascaded to adjacent cells, resulting in the release of smoke and fire. The incident resulted from Boeing's failure to incorporate…Jan 7, 2013 · JA829J · Minor damage