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 MIA72DKJ21Accident · No injuriesClosedPiper PA-25 · Ardmore, ALSep 8, 1971 · N7704Z · Substantial damage NTSB MIA72FKJ19Accident · Serious injuriesClosedBede BD-4 · Hazel Green, ALSep 5, 1971 · N4381F · Destroyed NTSB MIA72DKJ20Accident · No injuriesClosedCessna 188 · Slocomb, ALSep 4, 1971 · N5517S · Substantial damage NTSB MIA72AM021Accident · 2 fatalClosedPiper PA-22 · Morris, ALAug 29, 1971 · N8526D · Destroyed NTSB MIA72AM016Accident · 3 fatalClosedCessna 210A · Madison, ALAug 22, 1971 · N9432X · Destroyed NTSB MIA72IM013Incident · 1 fatalClosedCessna 150G · Foley, ALAug 17, 1971 · N3984J · No damage NTSB MIA72FKJ18Accident · No injuriesClosedGrumman G-164 · Southside, ALAug 16, 1971 · N960X · Substantial damage NTSB MIA72FKJ17Accident · No injuriesClosedPiper PA-28 · Attalla, ALAug 15, 1971 · N1692J · Substantial damage NTSB MIA72DKJ16Accident · No injuriesClosedPiper J-3 · Courtland, ALAug 13, 1971 · N3612N · Destroyed NTSB MIA72FKJ15Accident · No injuriesClosedCessna 150 · Gadsden, ALAug 11, 1971 · N22016 · Substantial damage NTSB MIA72DKJ14Accident · No injuriesClosedPiper PA-32 · Gadsden, ALAug 8, 1971 · N4726S · Substantial damage NTSB MIA72DKJ13Accident · No injuriesClosedPiper PA-25 · Muscle Shoals, ALAug 7, 1971 · N4414Y · Substantial damage NTSB MIA72FKJ22Accident · 1 fatalClosedAero Comdr A-9 · Aliceville, ALAug 5, 1971 · N8406V · Destroyed NTSB MIA72FKJ12Accident · No injuriesClosedAeronca 7DC · Clanton, ALAug 5, 1971 · N81741 · Substantial damage NTSB MIA72DKJ09Accident · No injuriesClosedPiper PA-28 · Montgomery, ALAug 2, 1971 · N9840W · Substantial damage NTSB MIA72FKJ11Accident · No injuriesClosedPiper PA-28 · Castleberry, ALJul 31, 1971 · N1754T · Substantial damage NTSB MIA72FKJ10Accident · No injuriesClosedPiper PA-22 · Meridianville, ALJul 31, 1971 · N5746Z · Destroyed NTSB MIA72DKJ08Accident · Minor injuriesClosedPiper PA-25 · Mooresville, ALJul 28, 1971 · N7432Z · Substantial damage NTSB MIA72KKJ07Accident · Minor injuriesClosedHiller FH1100 · Birmingham, ALJul 17, 1971 · N5058F · Substantial damage NTSB MIA72DKJ06Incident · No injuriesClosedM-Saulnier MS-760 · Huntsville, ALJul 16, 1971 · N760X · Minor damage NTSB MIA72DKJ04Accident · No injuriesClosedJeannies Teenie · Hazel Green, ALJul 12, 1971 · N11HN · Destroyed NTSB MIA72FKJ03Accident · Serious injuriesClosedPiper J3L-65 · Dothan, ALJul 10, 1971 · N27120 · Substantial damage NTSB MIA72FKJ02Accident · No injuriesClosedBoeing E75N1 · Echo, ALJul 9, 1971 · N66308 · Substantial damage NTSB MIA72DKJ05Accident · No injuriesClosedCessna 182 · Auburn, ALJul 9, 1971 · N9104G · Substantial damage NTSB MIA72FKJ01Accident · No injuriesClosedGrumman G-164 · Dothan, ALJul 1, 1971 · N748Y · Substantial damage NTSB MIA71FKJ64Accident · No injuriesClosedCessna 210 · Maxwell Afb, ALJun 24, 1971 · N9490T · Substantial damage NTSB MIA71AM115Accident · 2 fatalClosedBeech E18S · Birmingham, ALJun 22, 1971 · N5605D · Destroyed NTSB MIA71DKJ63Accident · No injuriesClosedCessna 172 · Crossville, ALJun 20, 1971 · N4637L · Substantial damage NTSB MIA71DKJ62Accident · No injuriesClosedCessna 150H · Montevallo, ALJun 20, 1971 · N7012S · Substantial damage NTSB MIA71DKJ61Accident · No injuriesClosedCessna 150 · Detroit, ALJun 12, 1971 · N23197 · Substantial damage NTSB MIA71DKJ60Accident · No injuriesClosedCessna 150 · Guin, ALJun 10, 1971 · N3914J · Substantial damage NTSB MIA71DKJ59Accident · No injuriesClosedCessna 150 · Muscle Shoals, ALJun 9, 1971 · N2968S · Substantial damage NTSB MIA71FKJ58Accident · No injuriesClosedBeech 95 · Anniston, ALJun 6, 1971 · N2033C · Substantial damage NTSB MIA71DKJ57Accident · No injuriesClosedCessna 310 · Tuscaloosa, ALJun 4, 1971 · N8172M · Substantial damage NTSB MIA71FKJ56Accident · No injuriesClosedCessna 177 · Jemison, ALJun 1, 1971 · N30133 · Substantial damage NTSB MIA71DLA48Accident · No injuriesClosedPiper PA-28 · Florala, ALMay 21, 1971 · N5540F · Substantial damage NTSB MIA71AM095Accident · 1 fatalClosedAeronca 7BCM · Headland, ALMay 9, 1971 · N1147E · Destroyed NTSB MIA71AM094Accident · 1 fatalClosedAeronca 7AC · Arab, ALMay 9, 1971 · N83857 · Destroyed NTSB MIA71DKJ54Accident · No injuriesClosedCessna 150 · Fort Deposit, ALMay 6, 1971 · N7902Z · Substantial damage NTSB MIA71FKJ52Accident · No injuriesClosedPiper PA-28 · Columbia, ALMay 2, 1971 · N3869K · Substantial damage NTSB MIA71DKJ51Accident · Minor injuriesClosedCessna 150J · Huntsville, ALMay 1, 1971 · N51365 · Substantial damage NTSB MIA71FKJ50Accident · No injuriesClosedPiper PA-22 · Pell City, ALApr 24, 1971 · N5303Z · Substantial damage NTSB MIA71FKJ49Accident · Minor injuriesClosedCessna 172H · Camden, ALApr 21, 1971 · N2660L · Substantial damage NTSB MIA71DKJ53Accident · No injuriesClosedPiper PA-25 · Mccullough, ALApr 20, 1971 · N7509Z · Substantial damage NTSB MIA71DKJ47Accident · No injuriesClosedPiper PA-24 · Tuscaloosa, ALApr 14, 1971 · N8350P · Substantial damage NTSB MIA71FKJ46Accident · No injuriesClosedCessna 150 · Florence, ALApr 11, 1971 · N8728S · Substantial damage NTSB MIA71FKJ45Accident · No injuriesClosedPiper PA-28 · Grady, ALApr 10, 1971 · N5735U · Substantial damage NTSB MIA71FKJ48Accident · No injuriesClosedCessna 150H · Weaver, ALApr 9, 1971 · N6520S · Substantial damage NTSB MIA71DKJ44Accident · Minor injuriesClosedCessna 182 · Toney, ALMar 20, 1971 · N2870F · Substantial damage NTSB MIA71FKJ43Accident · No injuriesClosedBeech D95A · Birmingham, ALMar 18, 1971 · N4835J · Substantial damage