Fatal NTSB investigations, AL
9 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1983 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 2007 | 2 |
Where
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.
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
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 MIA07FA098Accident · 1 fatalField investigationFinal reportHughes 369A · Moulton, ALThe separation of a main rotor blade from its tension torsion bar for an undetermined reason.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ATL88FA207Accident · 1 fatalField investigationFinal reportPiper PA-32 · Uniontown, ALNTSB 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…NTSB 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…NTSB 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…