Fatal NTSB investigations, 2018

14 cases where the sequence of events included Fire/smoke (post-impact).

Cases per year

20082026
Fatal NTSB investigations, 2018 per year, 2008–2026: 215 cases
200826
200919
20109
20117
20128
201317
201416
201520
201613
201713
201814
20198
20203
20215
202211
202311
202411
20253
20261

Latest 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 year(c.\"eventDate\") = 2018
    AND c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '170' 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.

NTSB ERA19LA078Accident · 1 fatalLimited investigationFinal reportBRM Aero Bristell S-LSA · Lakeland, FLThe student pilot's exceedance of the airplane's critical angle of attack during the initial climb, resulting in an aerodynamic stall from which the pilot did not recover.Dec 22, 2018 · N587BL · DestroyedNTSB ERA19FA060Accident · 2 fatalClass 2 · FieldFinal reportCessna 335 · Fort Lauderdale, FLThe pilot's improper decision to fly the unairworthy airplane and his failure to feather the left propeller following a partial loss of power from the left engine after takeoff. Also causal was the partial loss of power to the left engine due to detonation.Dec 1, 2018 · N79HP · DestroyedNTSB CEN19FA035Accident · 1 fatalField investigationFinal reportPiper PA 30 · Marion, INThe pilot's exceedance of the airplane's critical angle of attack following a loss of the left engine power shortly after takeoff, which resulted in an aerodynamic stall at an altitude too low for recovery. Contributing to the accident was the loss of left…Nov 29, 2018 · N7751Y · DestroyedNTSB ERA19FA034Accident · 2 fatalField investigationFinal reportAutogyro Cavalon · Sebring, FLThe pilot's improper decision to operate the gyroplane in an unairworthy condition, which resulted in the cyclic pitch control disconnecting in flight. Contributing was the pilot's inability to maintain control of the helicopter utilizing the published…Oct 30, 2018 · N198LT · DestroyedNTSB CEN19FA018Accident · 1 fatalField investigationFinal reportEurocopter AS350 · Odanah, WIThe pilot's loss of helicopter control for undetermined reasons.Oct 29, 2018 · N910S · DestroyedNTSB CEN18FA387Accident · 1 fatalField investigationFinal reportBeech 200 · Oscoda, MIThe pilot's descent below minimum descent altitude during the nonprecision instrument approach for reasons that could not be determined based on the available information.Sep 25, 2018 · N241CK · DestroyedNTSB WPR18FA266Accident · 1 fatalClass 2 · FieldFinal reportBeech 33 · Cottonwood, AZThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.Sep 17, 2018 · N2031D · Substantial damageNTSB ERA18FA232Accident · 1 fatalField investigationFinal reportPiper PA22 · Island Pond, VTThe pilot's exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall.Aug 25, 2018 · N6936B · Substantial damageNTSB ANC18FA055Accident · 1 fatalClass 2 · FieldFinal reportDe Havilland DHC-2 · Willow, AKThe pilot's exceedance of the airplane's critical angle of attack during departure climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's improper decision to load the airplane beyond its allowable gross weight and center…Jul 19, 2018 · N9878R · DestroyedNTSB CEN18FA236Accident · 2 fatalField investigationFinal reportCessna P210N · Detroit, MIA total loss of engine power due to fuel exhaustion. Also causal was the pilot's failure to divert earlier in the flight to another airport to ensure that the airplane had an adequate fuel reserve, and the malfunction of the landing gear extension system for…Jun 24, 2018 · N3896P · Substantial damageNTSB ERA18FA150Accident · 1 fatalField investigationFinal reportPiper PA28 · Chesapeake, VAThe pilot's loss of airplane control due to spatial disorientation during the departure climb in instrument meteorological conditions.May 22, 2018 · N6177W · DestroyedNTSB CEN18FA144Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Williamsburg, PAThe pilot's failure to obtain an updated weather briefing before the flight and his subsequent loss of airplane control due to spatial disorientation while maneuvering in instrument meteorological conditions during a diversion to an alternate airport after…Apr 19, 2018 · N451TD · DestroyedNTSB CEN18FA116Accident · 2 fatalField investigationFinal reportPiper PA 31P · Laredo, TXAn engine malfunction for undetermined reasons and the subsequent loss of control, due to the pilot's improper decision to maneuver the airplane below minimum controllable airspeed and his improper response to the loss of engine power.Mar 8, 2018 · N82605 · DestroyedNTSB WPR18MA087Accident · 5 fatalClass 3 · MajorFinal reportEurocopter EC130 · Peach Springs, AZA loss of tail rotor effectiveness, the pilot’s subsequent loss of helicopter control, and collision with terrain during an approach to land in gusting, tailwind conditions in an area of potential downdrafts and turbulence.Feb 11, 2018 · N155GC · Destroyed