Fatal NTSB investigations, AL

9 cases where the first occurrence was “Airframe/component/system failure/malfunction”.

Cases per year

19832026
Fatal NTSB investigations, AL per year, 1983–2026: 9 cases
19831
19851
19861
19881
19911
19941
19951
20072

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 c.\"eventStateOrRegion\" = 'AL' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
    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\" = 130)
  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 MIA07FA098Accident · 1 fatalField investigationFinal reportHughes 369A · Moulton, ALThe separation of a main rotor blade from its tension torsion bar for an undetermined reason.May 13, 2007 · N468WE · DestroyedNTSB ATL07LA066Accident · 1 fatalLimited investigationFinal reportSzybowcowy Zaklad Do SZD-36A · Sylacauga, ALThe pilot's improper installation of the left wing attachment pin, which allowed it to disengage during cruise flight, resulting in wing separation.Mar 31, 2007 · N6SZ · Substantial damageNTSB ATL95FA092Accident · 2 fatalField investigationFinal reportWittman O&O · Stevenson, ALAileron-wing flutter induced by separation at the trailing edge of an unbonded portion of wing fabric at an aileron wing station. The debonding of the wing fabric was a result of improper installation.Apr 27, 1995 · N41SW · DestroyedNTSB ATL94FA166Accident · 1 fatalField investigationFinal reportSchweizer SGS 1-34R · Maylene, ALThe pilot exceeding the design stress limits of the aircraft, resulting in an overload failure of the wing spar, and separation of the left wing from the aircraft. A factor was the pilot's lack of total flying experience in this model of aircraft.Aug 27, 1994 · N1132S · DestroyedNTSB ATL91LA066Accident · 1 fatalLimited investigationFinal reportBenson B8M · Hartselle, ALThe improper installation of the main rotor bearing block by the owner/pilot which resulted in the separation of the main rotor system.Mar 16, 1991 · N6572K · Substantial damageNTSB ATL88FA207Accident · 1 fatalField investigationFinal reportPiper PA-32 · Uniontown, ALJul 1, 1988 · N8324V · DestroyedNTSB ATL86FA082Accident · 2 fatalField investigationFinal reportBeech A23 · Russellville, ALOutboard half of one propeller blade separated during cruise flight. During the subsequent forced landing attempt the acft struck trees, severing the right wing, and crashed inverted. Front occupant seats separated from seat tracks. Examination of propeller…Feb 27, 1986 · N3536R · Substantial damageNTSB ATL85MA275Accident · 6 fatalMajor investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Eva, ALDrg an IFR arrival/dscnt, the plt stated he 'had to feather 1 eng, I have an oil leak & I'm just trying to dscnd . . .' He then said he was dscndg thru 5300'. As he contd the apch, he informed the controller he would be unable to go around since the hydr sys…Sep 13, 1985 · N680CC · DestroyedNTSB ATL83FA091Accident · 4 fatalField investigationFinal reportMooney M-20A · Prattville, ALThe left wing separated as the plt began a pull-up after a low pass. The separation point was in the wing root where themain spar had been secured to the fuselage with a metal bracket. A butt splice had been made to the bottom of the wing spar. The fracture…Jan 29, 1983 · N8146E · Destroyed