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 MIA67F0517Accident · No injuriesClosedPiper PA-23 · Birmingham, ALMay 16, 1967 · N1303P · Substantial damage NTSB MIA67D0518Accident · Minor injuriesClosedCessna 150G · Cullman, ALApr 30, 1967 · N2226J · Destroyed NTSB MIA67D0512Accident · No injuriesClosedCessna 182H · Troy, ALApr 26, 1967 · N2031X · Substantial damage NTSB MIA67A0111Accident · Serious injuriesClosedBell 47G-3B · Athens, ALApr 24, 1967 · N8494E · Destroyed NTSB MIA67A0105Accident · Minor injuriesClosedBell 47G-2 · Foley, ALApr 8, 1967 · N6714D · Substantial damage NTSB MIA67F0515Accident · No injuriesClosedNavion A · Alexander Cty, ALApr 6, 1967 · N4321K · Substantial damage NTSB MIA67F0492Accident · Serious injuriesClosedBoeing A75N1 · Bessemer, ALApr 4, 1967 · N7835B · Destroyed NTSB MIA67D0503Accident · Minor injuriesClosedCessna 140A · Huntsville, ALApr 2, 1967 · N9688A · Substantial damage NTSB MIA67A0100Accident · 2 fatalClosedCessna 195B · Vina, ALMar 29, 1967 · N3876V · Destroyed NTSB MIA67D0549Accident · No injuriesClosedPiper PA-28 · Huntsville, ALMar 25, 1967 · N5581W · Substantial damage NTSB MIA67F0489Accident · No injuriesClosedPiper PA-23 · Auburn, ALMar 19, 1967 · N3423P · Substantial damage NTSB MIA67F0443Accident · No injuriesClosedCessna 210 · Selma, ALMar 18, 1967 · N9694T · Substantial damage NTSB MIA67F0494Accident · No injuriesClosedBeech D50 · Birmingham, ALMar 15, 1967 · N4963B · Substantial damage NTSB MIA67A0093Accident · 1 fatalClosedPiper J3C-65 · Fosters, ALMar 10, 1967 · N92295 · Destroyed NTSB MIA67D0447Accident · No injuriesClosedPiper PA-28 · Monroeville, ALFeb 28, 1967 · N7531R · Substantial damage NTSB MIA67F0502Accident · Serious injuriesClosedMooney M20C · Birmingham, ALFeb 25, 1967 · N6266U · Substantial damage NTSB MIA67D0472Accident · No injuriesClosedBeech E18S · Fairhope, ALFeb 17, 1967 · N46M · Substantial damage NTSB MIA67A0082Accident · 3 fatalClosedPiper PA-30 · Dothan, ALFeb 4, 1967 · N8195Y · Destroyed NTSB MIA67D0465Accident · No injuriesClosedAero Comdr 560-E · Gadsden, ALJan 28, 1967 · N6225D · Substantial damage NTSB MIA67D0462Accident · No injuriesClosedPiper PA-28 · Courtland, ALJan 19, 1967 · N7189W · Substantial damage NTSB MIA67F0402Accident · No injuriesClosedCessna 175 · Lanett, ALJan 18, 1967 · N7434M · Substantial damage NTSB MIA67D0464Accident · No injuriesClosedCessna 172 · Northport, ALJan 7, 1967 · N3951L · Substantial damage NTSB MIA67A0074Accident · 1 fatalClosedCessna 210F · Muscle Shoals, ALJan 3, 1967 · N5813F · Destroyed NTSB MIA67F0351Accident · No injuriesClosedCessna 310 · Birmingham, ALJan 2, 1967 · N8115M · Substantial damage NTSB MIA67A0075Accident · No injuriesClosedBeech D18S · Muscle Shoals, ALJan 2, 1967 · N81L · Substantial damage NTSB MIA67A0072Accident · 2 fatalClosedPiper PA-22 · Manila, ALJan 2, 1967 · N8107C · Destroyed NTSB MIA67F0398Accident · No injuriesClosedBeech 95-A55 · Bessemer, ALDec 26, 1966 · N1449G · Substantial damage NTSB MIA67D0463Accident · No injuriesClosedCessna 182 · Huntsville, ALDec 24, 1966 · N2600G · Substantial damage NTSB MIA67F0388Accident · No injuriesClosedAeronca 11AC · Centre, ALDec 17, 1966 · N85873 · Substantial damage NTSB MIA67F0389Accident · No injuriesClosedPiper PA-28 · Andalusia, ALDec 16, 1966 · N6112W · Substantial damage NTSB MIA67D0338Accident · No injuriesClosedCessna 150F · Decatur, ALNov 30, 1966 · N7797F · Substantial damage NTSB MIA67F0363Accident · No injuriesClosedPiper PA-24 · Auburn, ALNov 26, 1966 · N8371P · Substantial damage NTSB MIA67F0293Accident · No injuriesClosedBellanca 14-13- · Bessemer, ALNov 26, 1966 · N86761 · Substantial damage NTSB MIA67D0312Accident · No injuriesClosedPiper L-4 · Guntersville, ALNov 24, 1966 · N42933 · Substantial damage NTSB MIA67D0554Accident · No injuriesClosedCessna 337 · Hartselle, ALNov 12, 1966 · N6357F · Substantial damage NTSB MIA67F0302Accident · Serious injuriesClosedCessna 150F · Scottsboro, ALNov 6, 1966 · N8163F · Destroyed NTSB MIA67F0303Accident · No injuriesClosedPiper PA-23 · Birmingham, ALNov 5, 1966 · N5203Y · Substantial damage NTSB MIA67A0056Accident · 2 fatalClosedBeech D18S · Heflin, ALNov 2, 1966 · N411Z · Destroyed NTSB MIA67A0055Accident · 2 fatalClosedPiper PA-28 · Greenville, ALNov 1, 1966 · N7802W · Destroyed NTSB MIA67D0283Accident · No injuriesClosedCessna 150 · Eufaula, ALOct 30, 1966 · N8312G · Substantial damage NTSB MIA67D0315Accident · No injuriesClosedPiper PA-24 · Montgomery, ALOct 25, 1966 · N5051P · Substantial damage NTSB MIA67F0276Accident · No injuriesClosedCessna 150 · Mobile, ALOct 22, 1966 · N7752F · Substantial damage NTSB MIA67A0052Accident · Serious injuriesClosedAir-Space 18A · Birmingham, ALOct 22, 1966 · N6149S · Substantial damage NTSB MIA67D0282Accident · No injuriesClosedCessna 172 · Jasper, ALOct 19, 1966 · N5372R · Substantial damage NTSB MIA67D0269Accident · No injuriesClosedMooney M20C · Sylacauga, ALOct 19, 1966 · N6802U · Substantial damage NTSB MIA67D0314Accident · No injuriesClosedCessna 150 · Huntsville, ALOct 12, 1966 · N8728S · Substantial damage NTSB MIA67D0300Accident · No injuriesClosedAeronca 11AC · Weaver, ALOct 8, 1966 · N9618E · Substantial damage NTSB MIA67D0242Accident · Minor injuriesClosedPiper J-3 · Florence, ALSep 24, 1966 · N98069 · Substantial damage NTSB MIA67D0210Accident · No injuriesClosedN.American P-51 · Eutaw, ALSep 18, 1966 · N351D · Substantial damage NTSB MIA67F0161Accident · No injuriesClosedPiper J3C-65 · Fort Payne, ALSep 7, 1966 · N32612 · Substantial damage