Skip to content

NTSB investigations, AL

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

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 c."eventStateOrRegion" = 'AL' AND c."eventCountry" = 'USA' 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 c.\"eventStateOrRegion\" = 'AL' AND c.\"eventCountry\" = 'USA'
  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'
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 MIA67D0281Accident · No injuriesClosedCessna 172 · Hazel Green, ALSep 1, 1966 · N5748R · Substantial damage NTSB MIA67F0167Accident · Minor injuriesClosedPiper PA-28 · Auburn, ALAug 25, 1966 · N8118W · Substantial damage NTSB MIA67F0192Accident · No injuriesClosedAero Comdr 520 · Mobile, ALAug 19, 1966 · N4162B · Substantial damage NTSB MIA67A0026Accident · 1 fatalClosedPiper PA-18A · Eufaula Ala, ALAug 19, 1966 · N8675C · Destroyed NTSB MIA67D0191Accident · Minor injuriesClosedPiper PA-25 · Harpersville, ALAug 17, 1966 · N6433Z · Substantial damage NTSB MIA67D0153Accident · No injuriesClosedCessna 210 · Decatur, ALAug 11, 1966 · N4986U · Substantial damage NTSB MIA67F0094Accident · Minor injuriesClosedCessna 150 · Bessemer, ALAug 6, 1966 · N3987V · 2 aircraft · Substantial damage NTSB MIA67F0085Accident · Serious injuriesClosedPiper PA-28 · Cullman, ALAug 3, 1966 · N8030W · Substantial damage NTSB MIA67D0093Accident · No injuriesClosedCessna 172 · Birmingham, ALJul 28, 1966 · N3823L · Substantial damage NTSB MIA67F0060Accident · Serious injuriesClosedPiper PA-25 · Eufaula, ALJul 23, 1966 · N7486Z · Destroyed NTSB MIA67D0387Accident · Minor injuriesClosedCessna 150 · Phil Campbell, ALJul 23, 1966 · N6211T · Substantial damage NTSB MIA67A0011Accident · 2 fatalClosedPiper PA-30 · Gordo, ALJul 22, 1966 · N7602Y · Destroyed NTSB MIA67O0070Accident · No injuriesClosedCessna 170 · Evergreen, ALJul 15, 1966 · N5407C · Substantial damage NTSB MIA67D0141Accident · No injuriesClosedCessna 172 · Millers Ferry, ALJul 14, 1966 · N1460Y · Substantial damage NTSB MIA67D0127Accident · No injuriesClosedPiper PA-28 · Enterprise, ALJul 10, 1966 · N7042R · Substantial damage NTSB MIA67D0109Accident · No injuriesClosedLuscombe 8E · Gadsen, ALJul 10, 1966 · N2634K · Substantial damage NTSB MIA67D0106Accident · No injuriesClosedBeech 23 · Mobile, ALJul 10, 1966 · N2308Z · Substantial damage NTSB MIA67D0098Accident · No injuriesClosedCessna 195 · Weaver, ALJul 9, 1966 · N6394D · Substantial damage NTSB MIA66A0149Accident · 4 fatalClosedPiper PA-23 · Ashland, ALJun 27, 1966 · N5775Y · Destroyed NTSB MIA67D0068Accident · No injuriesClosedMaule M-4 · Decatur, ALJun 22, 1966 · N9814M · Substantial damage NTSB MIA67D0535Accident · No injuriesClosedCessna 172 · Brewton, ALJun 20, 1966 · N4021F · Substantial damage NTSB MIA67D0096Accident · No injuriesClosedCessna 337 · Mobile, ALJun 6, 1966 · N2283X · Substantial damage NTSB MIA66A0134Accident · 1 fatalClosedCessna 172F · Dothan, ALMay 16, 1966 · N5701R · Destroyed NTSB MIA66F0534Accident · No injuriesClosedPiper PA-18 · Selma, ALMay 13, 1966 · N9132D · Substantial damage NTSB MIA66A0129Accident · 2 fatalClosedPiper PA-18 · Atmore, ALMay 3, 1966 · N1119C · Destroyed NTSB MIA66D0538Accident · No injuriesClosedPiper PA-23 · Foley, ALApr 24, 1966 · N5208Y · Substantial damage NTSB MIA66F0504Accident · No injuriesClosedPiper PA-28 · Birmingham, ALApr 16, 1966 · N6735W · Substantial damage NTSB MIA66D0494Accident · No injuriesClosedPiper PA-28 · Selma, ALApr 10, 1966 · N4585R · Substantial damage NTSB MIA66D0485Accident · No injuriesClosedCessna 172 · Muscle Shoals, ALApr 2, 1966 · N7426X · Substantial damage NTSB MIA66D0458Accident · No injuriesClosedCessna 182 · Birmingham, ALMar 27, 1966 · N9215X · Substantial damage NTSB MIA66D0523Accident · No injuriesClosedCessna 182 · Huntsville, ALMar 26, 1966 · N2140R · Substantial damage NTSB MIA66D0478Accident · No injuriesClosedCessna 182 · Florence, ALMar 25, 1966 · N8503T · Substantial damage NTSB MIA66D0480Accident · No injuriesClosedCessna 182 · Florence, ALMar 20, 1966 · N2195G · Substantial damage NTSB MIA66D0481Accident · No injuriesClosedCessna P206 · Bessemer, ALMar 19, 1966 · N2537X · Substantial damage NTSB MIA66D0471Accident · No injuriesClosedPiper PA-28 · Birmingham, ALMar 10, 1966 · N6933W · Substantial damage NTSB MIA66D0460Accident · No injuriesClosedPiper PA-22 · Foley, ALMar 5, 1966 · N8135C · Substantial damage NTSB MIA66A0101Accident · Minor injuriesClosedDouglas DC-6 · Birmingham, ALMar 3, 1966 · N1904M · Substantial damage NTSB MIA66F0426Accident · No injuriesClosedPiper PA-16 · Artselle, ALFeb 26, 1966 · N6836K · Substantial damage NTSB MIA66D0421Accident · No injuriesClosedCessna 150 · Anniston, ALFeb 19, 1966 · N3987U · Substantial damage NTSB MIA66A0087Accident · 2 fatalClosedCessna 310G · Ft.Payne, ALFeb 9, 1966 · N8977Z · Destroyed NTSB MIA66F0422Accident · No injuriesClosedPiper PA-24 · Montgomery, ALFeb 6, 1966 · N5243P · Substantial damage NTSB MIA66F0443Accident · Minor injuriesClosedAeronca L-16 · Muscle Shoals, ALFeb 5, 1966 · N65885 · 2 aircraft · Destroyed NTSB MIA66I0083Incident · No injuriesClosedConvair CV-440 · Mobile, ALJan 17, 1966 · N9314 · No damage NTSB MIA66F0397Accident · No injuriesClosedNavion A · Montgomery, ALJan 12, 1966 · N91616 · Substantial damage NTSB MIA66A0081Accident · 2 fatalClosedPiper J3 · Piedmont, ALJan 8, 1966 · N92358 · Destroyed NTSB MIA66A0076Accident · 2 fatalClosedPiper PA-24 · Steele, ALJan 1, 1966 · N6966P · Destroyed NTSB MIA66F0395Accident · Minor injuriesClosedPiper PA-24 · Dothan, ALDec 26, 1965 · N5204P · Substantial damage NTSB MIA66F0390Accident · No injuriesClosedLuscombe 8A · Bay Minette, ALDec 26, 1965 · N71928 · Substantial damage NTSB MIA66A0072Accident · 1 fatalClosedMooney M-18C · Newbern, ALDec 25, 1965 · N4190 · Destroyed NTSB MIA66A0071Accident · No injuriesClosedPiper PA-23 · Huntsville, ALDec 21, 1965 · N5636Y · Substantial damage