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 MIA73AM007Accident · 2 fatalClosedBeech B95 · Shelby Sprngs, ALJul 5, 1972 · N902T · Destroyed NTSB MIA73DKJ01Accident · No injuriesClosedCessna 188 · Prattville, ALJul 2, 1972 · N21717 · Substantial damage NTSB MIA73AM002Accident · 1 fatalClosedPiper PA-28R · Hillsboro, ALJul 1, 1972 · N3826T · Destroyed NTSB MIA72FKJ66Accident · No injuriesClosedBeech 23 · Birmingham, ALJun 29, 1972 · N14BW · Substantial damage NTSB MIA72DKJ65Accident · No injuriesClosedBeech A23 · Catherine, ALJun 28, 1972 · N3532R · Substantial damage NTSB MIA72DKJ64Accident · No injuriesClosedCessna 150F · Mobile, ALJun 25, 1972 · N8192F · Substantial damage NTSB MIA72DKJ61Accident · No injuriesClosedBeech B35 · Talladega, ALJun 13, 1972 · N5015C · Substantial damage NTSB MIA72FKJ59Accident · 1 fatalClosedPiper PA-18A · Robertsdale, ALJun 5, 1972 · N4391A · Destroyed NTSB MIA72DKJ62Accident · No injuriesClosedAeronca 7AC · Corner, ALJun 4, 1972 · N85188 · Substantial damage NTSB MIA72DKJ58Accident · No injuriesClosedLuscombe 8A · Pell City, ALJun 4, 1972 · N77837 · Substantial damage NTSB MIA72DKJ60Accident · No injuriesClosedAeronca 7AC · Selma, ALMay 31, 1972 · N4160E · Substantial damage NTSB MIA72FKJ57Accident · Serious injuriesClosedStarduster TOO · Alabaster, ALMay 28, 1972 · N3650 · Destroyed NTSB MIA72DKJ56Accident · No injuriesClosedPiper PA-28 · Madison, ALMay 27, 1972 · N465FL · Substantial damage NTSB MIA72DKJ63Accident · No injuriesClosedAero Comdr Thrush · Pell City, ALMay 23, 1972 · N8974Q · Substantial damage NTSB MIA72FKJ53Accident · No injuriesClosedPiper PA-30 · Huntsville, ALMay 20, 1972 · N7102Y · Substantial damage NTSB MIA72DKJ54Accident · No injuriesClosedSchweizer SGS233 · Estaboga, ALMay 20, 1972 · N2496W · Substantial damage NTSB MIA72FKJ55Accident · No injuriesClosedCessna A188A · Marion, ALMay 17, 1972 · N2157U · Substantial damage NTSB MIA72FKJ52Accident · No injuriesClosedPiper PA-24 · Birmingham, ALApr 23, 1972 · N5496P · Substantial damage NTSB MIA72FKJ50Accident · No injuriesClosedPiper PA-22 · Lacey Springs, ALApr 18, 1972 · N3231B · Destroyed NTSB MIA72DKJ51Accident · No injuriesClosedAeronca 7AC · Atmore, ALApr 9, 1972 · N2821E · Substantial damage NTSB MIA72AM107Accident · 7 fatalClosedPiper PA-32 · Fort Payne, ALApr 9, 1972 · N3953W · Destroyed NTSB MIA72DKJ49Accident · No injuriesClosedPiper PA-24 · Uniontown, ALApr 4, 1972 · N6394P · Substantial damage NTSB MIA72FKJ48Accident · No injuriesClosedBeech 55 · Birmingham, ALApr 1, 1972 · N661MW · Substantial damage NTSB MIA72AM100Accident · 2 fatalClosedPiper J3C-65 · Sylacauga, ALMar 26, 1972 · N70568 · Destroyed NTSB MIA72AM099Accident · 1 fatalClosedPiper PA-28 · Repton, ALMar 24, 1972 · N9031W · Destroyed NTSB MIA72FKJ46Accident · No injuriesClosedPiper PA-39 · Scottsboro, ALMar 22, 1972 · N8901Y · Substantial damage NTSB MIA72DKJ45Accident · No injuriesClosedPiper PA-23 · Decatur, ALMar 16, 1972 · N4959P · Substantial damage NTSB MIA72DKJ44Accident · No injuriesClosedCessna 172K · Dothan, ALMar 16, 1972 · N79575 · Substantial damage NTSB MIA72AM085Accident · 2 fatalClosedPiper PA-28 · Wing, ALFeb 26, 1972 · N4717L · Destroyed NTSB MIA72DKJ43Accident · No injuriesClosedLuscombe 8F · Ozark, ALFeb 21, 1972 · N829B · Destroyed NTSB MIA72DKJ42Accident · No injuriesClosedCessna 172 · Dauphin Is, ALFeb 20, 1972 · N7455G · Substantial damage NTSB MIA72DKJ41Accident · No injuriesClosedCessna 310 · Ardmore, ALFeb 12, 1972 · N316D · Substantial damage NTSB MIA72FKJ40Accident · No injuriesClosedPiper PA-24 · Montgomery, ALFeb 3, 1972 · N5663P · Substantial damage NTSB MIA72AM073Accident · 3 fatalClosedCessna 210B · Semmes, ALJan 23, 1972 · N9715X · Destroyed NTSB MIA72AM072Accident · 1 fatalClosedCessna 310D · Bear Creek, ALJan 20, 1972 · N6993T · Destroyed NTSB MIA72FKJ39Accident · Minor injuriesClosedPiper PA-28 · Mobile, ALJan 2, 1972 · N1856T · Substantial damage NTSB MIA72FKJ37Accident · Minor injuriesClosedTaylorcraft DCO-65 · Mobile, ALDec 24, 1971 · N52423 · Substantial damage NTSB MIA72FKJ36Accident · 1 fatalClosedCessna 172F · Oneonta, ALDec 24, 1971 · N7856U · Destroyed NTSB MIA72DKJ35Accident · No injuriesClosedMooney M20C · Jasper, ALNov 28, 1971 · N9078V · Substantial damage NTSB MIA72DKJ34Accident · No injuriesClosedCessna 150G · Owens X-Rds, ALNov 25, 1971 · N3124J · Substantial damage NTSB MIA72DKJ32Accident · No injuriesClosedPiper PA-28 · Auburn, ALNov 23, 1971 · N5957W · Substantial damage NTSB MIA72AM047Accident · 1 fatalClosedCessna 182E · Heflin, ALNov 21, 1971 · N2946Y · Destroyed NTSB MIA72DKJ33Accident · No injuriesClosedPiper PA-32 · Montgomery, ALNov 16, 1971 · N8660N · Substantial damage NTSB MIA72FKJ31Accident · No injuriesClosedBeech 65-A80 · Birmingham, ALNov 13, 1971 · N277Q · Substantial damage NTSB MIA72DKJ30Accident · No injuriesClosedCessna 210 · Jasper, ALOct 28, 1971 · N7472E · Substantial damage NTSB MIA72DKJ29Accident · No injuriesClosedCessna 172G · Opelika, ALOct 22, 1971 · N3951L · Substantial damage NTSB MIA72DKJ28Accident · No injuriesClosedCessna 310 · Troy, ALOct 12, 1971 · N8988Z · Substantial damage NTSB MIA72DKJ26Accident · No injuriesClosedAero Comdr 680T · Mobile, ALOct 1, 1971 · N5051E · Substantial damage NTSB MIA72DKJ24Accident · No injuriesClosedCessna 150 · Arab, ALSep 25, 1971 · N6063G · Substantial damage NTSB MIA72FKJ25Accident · No injuriesClosedCessna 195 · Benton, ALSep 12, 1971 · N3895V · Substantial damage