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 MIA74DKJ01Accident · No injuriesClosedAmer Avco AA5 · Centreville, ALJul 3, 1974 · N5840L · Substantial damage NTSB MIA74DKJ64Accident · Minor injuriesClosedBensen B8M · Fairhope, ALJun 30, 1974 · N62518 · Substantial damage NTSB MIA74DKJ63Accident · No injuriesClosedGrumman G-164 · Moundville, ALJun 16, 1974 · N9725 · Substantial damage NTSB MIA74DKJ62Accident · No injuriesClosedCessna 172 · Slocomb, ALJun 16, 1974 · N2485Y · Substantial damage NTSB MIA74DKJ61Accident · No injuriesClosedBell 47G-4 · Gaylesville, ALJun 14, 1974 · N1160W · Substantial damage NTSB MIA74DKJ60Accident · No injuriesClosedBeech E35 · Lacey Springs, ALJun 11, 1974 · N7300B · Substantial damage NTSB MIA74DKJ59Accident · Minor injuriesClosedCessna 170 · Clanton, ALMay 18, 1974 · N2697V · Substantial damage NTSB MIA74FKJ57Accident · 1 fatalClosedCessna 210E · Bay Minette, ALMay 13, 1974 · N4918U · Destroyed NTSB MIA74DKJ58Accident · Minor injuriesClosedMooney M20C · Auburn, ALMay 12, 1974 · N5575Q · Substantial damage NTSB MIA74FKJ55Accident · No injuriesClosedCessna 150 · Brewton, ALMay 7, 1974 · N5612G · Substantial damage NTSB MIA74DKJ54Accident · No injuriesClosedBellanca 17-31A · Huntsville, ALMay 7, 1974 · N6585V · Substantial damage NTSB MIA74IM090Incident · Minor injuriesClosedBoeing 737 · Birmingham, ALMay 5, 1974 · N9044U · Minor damage NTSB MIA74DKJ53Accident · No injuriesClosedAeronca 7AC · Ft Payne, ALApr 29, 1974 · N1208E · Substantial damage NTSB MIA74DKJ52Accident · No injuriesClosedMurrayair MA-1 · Uniontown, ALApr 26, 1974 · N97063 · Substantial damage NTSB MIA74DKJ51Accident · No injuriesClosedCessna 180 · Elberta, ALApr 21, 1974 · N9377T · Substantial damage NTSB MIA74DKJ30Accident · No injuriesClosedStinson 108 · Dothan, ALApr 7, 1974 · N925D · Substantial damage NTSB MIA74DKJ46Accident · No injuriesClosedCessna 180 · Opelika, ALMar 14, 1974 · N3455G · Substantial damage NTSB MIA74AM075Accident · 2 fatalClosedCessna 150L · Bessemer, ALFeb 26, 1974 · N1355Q · Destroyed NTSB MIA74FKJ45Accident · Serious injuriesClosedCessna 210B · Huntsville, ALFeb 6, 1974 · N9691X · Substantial damage NTSB MIA74FKJ48Accident · 1 fatalClosedB-Jungman BU-131 · Monroeville, ALJan 31, 1974 · N2348 · Destroyed NTSB MIA74DKJ43Accident · No injuriesClosedPiper PA-28 · Auburn, ALJan 31, 1974 · N4617R · Substantial damage NTSB MIA74AM061Accident · 1 fatalClosedCessna 182J · Birmingham, ALJan 23, 1974 · N3532F · Destroyed NTSB MIA74DKJ42Accident · No injuriesClosedAero Comdr 680T · Montgomery, ALJan 15, 1974 · N8086U · Substantial damage NTSB MIA74DKJ44Accident · No injuriesClosedPiper PA-30 · Decatur, ALJan 14, 1974 · N7739Y · Substantial damage NTSB MIA74FKJ41Accident · Serious injuriesClosedAeronca 7FC · Addison, ALJan 8, 1974 · N511B · Substantial damage NTSB MIA74DKJ40Accident · No injuriesClosedPiper PA-32 · Jasper, ALJan 4, 1974 · N4061R · Substantial damage NTSB MIA74DKJ39Accident · No injuriesClosedMooney M20E · Sylacauga, ALJan 1, 1974 · N7198U · Substantial damage NTSB MIA74AM052Accident · 2 fatalClosedRyan PT-22 · Auburn, ALJan 1, 1974 · N170P · Destroyed NTSB MIA74AM051Accident · 2 fatalClosedMooney M20F · Huntsville, ALDec 30, 1973 · N9619M · Destroyed NTSB MIA74DKJ38Accident · No injuriesClosedBeech B95 · Birmingham, ALDec 21, 1973 · N2710Y · Substantial damage NTSB MIA74DKJ37Accident · No injuriesClosedCessna 182 · Hazel Green, ALDec 21, 1973 · N3186Y · Substantial damage NTSB MIA74DKJ36Accident · No injuriesClosedCessna 207 · Troy, ALDec 17, 1973 · N91061 · Substantial damage NTSB MIA74DKJ35Accident · Minor injuriesClosedPitts S-2A · Letohatchee, ALDec 16, 1973 · N80029 · Destroyed NTSB MIA74DKJ34Accident · No injuriesClosedTradewind C-45H · Jasper, ALDec 10, 1973 · N711FW · Substantial damage NTSB MIA74DKJ33Accident · No injuriesClosedCessna 182 · New Hope, ALNov 30, 1973 · N217CC · Substantial damage NTSB MIA74AM048Accident · 1 fatalClosedCessna 150H · Ashland, ALNov 24, 1973 · N22591 · Destroyed NTSB MIA74DKJ32Accident · Minor injuriesClosedCessna 206 · Huntsville, ALNov 22, 1973 · N4628F · Substantial damage NTSB MIA74AM046Accident · 1 fatalClosedAero Comdr 680-E · Birmingham, ALNov 22, 1973 · N277LP · Destroyed NTSB MIA74AM045Accident · 1 fatalClosedPiper PA-32 · Evergreen, ALNov 20, 1973 · N8665N · Destroyed NTSB MIA74DKJ30Accident · No injuriesClosedCessna 210 · Alabaster, ALNov 11, 1973 · N734SC · Substantial damage NTSB MIA74DKJ29Accident · No injuriesClosedAero Comdr 720 · Birmingham, ALOct 12, 1973 · N825WD · Substantial damage NTSB MIA74DKJ27Accident · No injuriesClosedPiper PA-28R · Tuscaloosa, ALOct 5, 1973 · N1434T · Substantial damage NTSB MIA74DKJ25Accident · No injuriesClosedPiper PA-23 · Robertsdale, ALSep 21, 1973 · N4510P · Substantial damage NTSB MIA74AM024Accident · 1 fatalClosedCessna 182P · Red Level, ALSep 15, 1973 · N9348G · Destroyed NTSB MIA74DKJ24Accident · No injuriesClosedPiper PA-22 · Daphne, ALSep 9, 1973 · N3425Z · Substantial damage NTSB MIA74DKJ22Accident · No injuriesClosedPiper PA-34 · Huntsville, ALSep 4, 1973 · N55697 · Substantial damage NTSB MIA74DKJ21Accident · No injuriesClosedWaco UPF-7 · Huntsville, ALAug 30, 1973 · N29982 · Substantial damage NTSB MIA74DKJ20Accident · No injuriesClosedAero Comdr A-9B · Hazel Green, ALAug 28, 1973 · N7726V · Substantial damage NTSB MIA74DKJ19Accident · No injuriesClosedAeronca 7AC · Vallermosa Sp, ALAug 25, 1973 · N85162 · Substantial damage NTSB MIA74DKJ18Accident · No injuriesClosedAeronca 7AC · Clanton, ALAug 25, 1973 · N83608 · Substantial damage