Skip to content

NTSB investigations, AL

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 MIA76FKJ73Accident · Serious injuriesClosedBell 204B · Ozark, ALJun 17, 1976 · N8513F · Substantial damage NTSB MIA76DKJ75Accident · No injuriesClosedChampion 7ECA · Goodway, ALJun 17, 1976 · N2543F · Substantial damage NTSB MIA76DKJ72Accident · No injuriesClosedRyan ST-3KR · Fairhope, ALJun 17, 1976 · N53430 · Substantial damage NTSB MIA76DKJ71Accident · No injuriesClosedHughes 269B · Laceys Spring, ALJun 16, 1976 · N9435F · Substantial damage NTSB MIA76FKJ74Accident · No injuriesClosedPiper PA-22 · Talladega, ALJun 13, 1976 · N8049D · Substantial damage NTSB MIA76FKJ70Accident · No injuriesClosedPiper PA-28 · Birmingham, ALJun 13, 1976 · N33396 · Substantial damage NTSB MIA76FKJ69Accident · No injuriesClosedPiper PA-25 · Dothan, ALJun 8, 1976 · N4619Y · Substantial damage NTSB MIA76DKJ68Accident · Minor injuriesClosedGrumman G-164 · Perdido Beach, ALJun 7, 1976 · N10245 · Destroyed NTSB MIA76DKJ67Accident · No injuriesClosedCessna 172A · Bessemer, ALJun 6, 1976 · N7432T · Substantial damage NTSB MIA76DKJ66Accident · No injuriesClosedCessna 150 · Russellville, ALJun 6, 1976 · N3060X · Substantial damage NTSB MIA76DKJ65Accident · No injuriesClosedPiper PA-28 · Montgomery, ALMay 29, 1976 · N4421T · Substantial damage NTSB MIA76DKJ64Accident · No injuriesClosedCessna 210 · Andalusia, ALMay 28, 1976 · N3775Y · Substantial damage NTSB MIA76DKJ63Accident · No injuriesClosedPiper PA-30 · Monroeville, ALMay 24, 1976 · N718JR · Substantial damage NTSB MIA76FKJ62Accident · Serious injuriesClosedCessna A188B · Mobile, ALMay 19, 1976 · N9013R · Destroyed NTSB MIA76AM085Accident · 1 fatalClosedCessna 210G · Livingston, ALMay 16, 1976 · N5890F · Destroyed NTSB MIA76FKJ61Accident · No injuriesClosedSwearingen SA26AT · Birmingham, ALMay 10, 1976 · N101TT · Substantial damage NTSB MIA76DKJ60Accident · No injuriesClosedCessna 150 · Lanett, ALApr 28, 1976 · N7830Z · Substantial damage NTSB MIA76AM079Accident · 3 fatalClosedPiper PA-28 · Dauphin Island, ALApr 23, 1976 · N2894T · Destroyed NTSB MIA76DKJ58Accident · No injuriesClosedCessna 150L · Jasper, ALApr 18, 1976 · N1634Q · Substantial damage NTSB MIA76AM075Accident · 2 fatalClosedPiper PA-28R · Montgomery, ALApr 3, 1976 · N41479 · Destroyed NTSB MIA76FKJ57Accident · No injuriesClosedBeech B35 · Huntsville, ALMar 23, 1976 · N8611Q · Substantial damage NTSB MIA76FKJ56Accident · Minor injuriesClosedStinson 108 · Priceville, ALMar 21, 1976 · N97402 · Substantial damage NTSB MIA76IM072Incident · No injuriesClosedBoeing 727 · Birmingham, ALMar 16, 1976 · N468DA · Minor damage NTSB MIA76AM073Accident · No injuriesClosedCessna 210H · Dothan, ALMar 16, 1976 · N2216R · Substantial damage NTSB MIA76DKJ54Accident · No injuriesClosedBreezy RLU-1 · Sylacauga, ALMar 8, 1976 · N55WW · Substantial damage NTSB MIA76DKJ53Accident · No injuriesClosedBell 47D1 · Enterprise, ALMar 6, 1976 · N3109G · Substantial damage NTSB MIA76AM070Accident · 1 fatalClosedCessna 337A · Greenville, ALMar 2, 1976 · N6346F · Destroyed NTSB MIA76FKJ52Accident · Minor injuriesClosedStarduster 2 · Huntsville, ALFeb 28, 1976 · N20DW · Substantial damage NTSB MIA76AM068Accident · 2 fatalClosedEnstrom F-28A · Guntersville, ALFeb 27, 1976 · N9263 · Substantial damage NTSB MIA76FKJ51Accident · Serious injuriesClosedCessna T210 · Birmingham, ALFeb 23, 1976 · N6146R · Destroyed NTSB MIA76FKJ50Accident · No injuriesClosedBeech 65 · Dothan, ALFeb 20, 1976 · N466DM · Substantial damage NTSB MIA76DKJ49Accident · No injuriesClosedPiper PA-12 · Phenix City, ALFeb 19, 1976 · N92561 · Substantial damage NTSB MIA76DKJ48Accident · Serious injuriesClosedPiper PA-32R · Atmore, ALFeb 12, 1976 · N7074C · Destroyed NTSB MIA76DKJ47Accident · No injuriesClosedAmer Avco AA1 · Munford, ALFeb 11, 1976 · N5746L · Substantial damage NTSB MIA76DKJ46Accident · No injuriesClosedCessna 210 · Lanett, ALJan 21, 1976 · N2358F · Substantial damage NTSB MIA76DKJ45Accident · Minor injuriesClosedDehavilland DHC-2 · Ozark, ALJan 15, 1976 · N49235 · Substantial damage NTSB MIA76FKJ44Accident · No injuriesClosedPiper PA-28R · Cleveland, ALJan 14, 1976 · N32240 · Substantial damage NTSB MIA76DKJ43Accident · No injuriesClosedBellanca 7KCAB · Davenport, ALJan 13, 1976 · N9104L · Substantial damage NTSB MIA76DKJ42Accident · No injuriesClosedCessna 172L · Forkland, ALJan 11, 1976 · N9881G · Substantial damage NTSB MIA76FKJ41Accident · Minor injuriesClosedMooney M20E · Alabaster, ALJan 2, 1976 · N5502Q · Substantial damage NTSB MIA76FKJ40Accident · No injuriesClosedBeech 65-80 · Birmingham, ALDec 31, 1975 · N1110P · Substantial damage NTSB MIA76DKJ38Accident · No injuriesClosedPiper PA-28 · Anniston, ALDec 19, 1975 · N5085W · Substantial damage NTSB MIA76DKJ37Accident · No injuriesClosedPiper PA-24 · Huntsville, ALDec 19, 1975 · N8883P · Substantial damage NTSB MIA76FKJ36Accident · Minor injuriesClosedMooney M21 · Alabaster, ALDec 17, 1975 · N7177U · Destroyed NTSB MIA76FKJ34Accident · No injuriesClosedHughes 269B · Birmingham, ALDec 15, 1975 · N9444F · Substantial damage NTSB MIA76AM043Accident · 1 fatalClosedCessna 182P · Huntsville, ALNov 20, 1975 · N5729J · Destroyed NTSB MIA76FKJ33Accident · No injuriesClosedPiper PA-24 · Birmingham, ALNov 18, 1975 · N5304P · Substantial damage NTSB MIA76DKJ32Accident · No injuriesClosedSchweizer 1-26C · Montevallo, ALNov 8, 1975 · N5747S · Substantial damage NTSB MIA76AM039Accident · 2 fatalClosedCessna 180 · Eufaula, ALNov 2, 1975 · N9100C · Substantial damage NTSB MIA76DKJ30Accident · Minor injuriesClosedCessna 150 · Tuscaloosa, ALOct 21, 1975 · N4225U · Substantial damage