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 MIA66F0135Accident · No injuriesClosedBoeing A75 · Tuscaloosa, ALJul 12, 1965 · N17694 · Substantial damage NTSB MIA66A0007Accident · Minor injuriesClosedBrantly B2 · Bessemer, ALJul 12, 1965 · N6796D · Destroyed NTSB MIA66D0048Accident · No injuriesClosedAeronca 7DC · Elmore, ALJul 11, 1965 · N81741 · Substantial damage NTSB MIA66A0003Accident · Minor injuriesClosedBell 47G-2 · Selma, ALJul 7, 1965 · N6714D · Substantial damage NTSB MIA66F0180Accident · Minor injuriesClosedBeechcraft BE23 · Lanett, ALJul 4, 1965 · N8743M · Substantial damage NTSB MIA66F0179Accident · No injuriesClosedMooney M20C · Huntsville, ALJul 3, 1965 · N7868V · Substantial damage NTSB MIA66F0136Accident · No injuriesClosedPiper PA-30 · Birmingham, ALJun 25, 1965 · N7276Y · Substantial damage NTSB MIA66F0008Accident · No injuriesClosedCessna 150 · Sylacauga, ALJun 20, 1965 · N7397X · Substantial damage NTSB MIA66F0007Accident · No injuriesClosedPiper PA-24 · Muscle Shoals, ALJun 16, 1965 · N8476P · Substantial damage NTSB MIA65D0125Accident · No injuriesClosedPiper PA-28 · Huntsville, ALJun 6, 1965 · N6676W · Substantial damage NTSB MIA65F0114Accident · No injuriesClosedCessna 140 · Bessemer, ALJun 4, 1965 · N3563V · Substantial damage NTSB MIA65D0107Accident · No injuriesClosedCessna 170B · Fairhope, ALMay 30, 1965 · N6135B · Substantial damage NTSB MIA66D0104Accident · No injuriesClosedErcoupe 415-C · Whitfield, ALMay 29, 1965 · N99337 · Substantial damage NTSB MIA66F0030Accident · Minor injuriesClosedMooney M20B · Hurtsboro, ALMay 28, 1965 · N74742 · Destroyed NTSB MIA66D0035Accident · No injuriesClosedCessna 175B · Wadley, ALMay 27, 1965 · N8286T · Substantial damage NTSB MIA66F0003Accident · Serious injuriesClosedBeechcraft 35 · Northport, ALMay 23, 1965 · N4505V · Destroyed NTSB MIA66F0053Accident · No injuriesClosedPiper PA-23 · Oxford, ALMay 19, 1965 · N5102Y · Substantial damage NTSB MIA65D0117Accident · No injuriesClosedBeechcraft K-35 · Grove Hill, ALMay 15, 1965 · N6079E · Substantial damage NTSB MIA65F0087Accident · No injuriesClosedCessna 310 · Bessemer, ALMay 6, 1965 · N3070D · Substantial damage NTSB MIA66F0103Accident · No injuriesClosedCessna 175 · Guntersville, ALMay 5, 1965 · N9260B · Substantial damage NTSB MIA65D0078Accident · No injuriesClosedPiper PA-28 · Hamilton, ALApr 26, 1965 · N5841W · Substantial damage NTSB MIA65F0116Accident · No injuriesClosedCessna 182 · Evergreen, ALApr 25, 1965 · N2357G · Destroyed NTSB MIA65A0105Accident · 2 fatalClosedCessna 172 · Evergreen, ALApr 24, 1965 · N8004B · Destroyed NTSB MIA65D0115Accident · No injuriesClosedPiper PA-28 · Muscle Shoals, ALApr 23, 1965 · N5542W · Substantial damage NTSB MIA65F0095Accident · No injuriesClosedCessna 310 · Bessemer, ALApr 18, 1965 · N310D · Substantial damage NTSB MIA65D0082Accident · No injuriesClosedCessna 175 · Tishabee, ALApr 4, 1965 · N7278M · Substantial damage NTSB MIA65A0095Accident · 3 fatalClosedPiper PA-23 · Drewry, ALMar 27, 1965 · N5327Y · Destroyed NTSB MIA65F0007Accident · No injuriesClosedPiper PA-30 · Birmingham, ALMar 24, 1965 · N7474Y · Substantial damage NTSB MIA65F0027Accident · No injuriesClosedMooney M20A · Birmingham, ALMar 19, 1965 · N1057C · Substantial damage NTSB MIA65A0092Accident · 1 fatalClosedCessna 150G · Auburn, ALMar 14, 1965 · N7966Z · Substantial damage NTSB UNK65X1468Accident · No injuriesClosedCessna 140 · Jamison, ALMar 7, 1965 · N72207 · Substantial damage NTSB MIA65A0088Accident · 2 fatalClosedPiper J3C · Atmore, ALFeb 28, 1965 · N70262 · Destroyed NTSB MIA65F0048Accident · Minor injuriesClosedAeronca 7AC · Ozark, ALFeb 23, 1965 · N84373 · Substantial damage NTSB UNK65X1403Accident · No injuriesClosedPiper PA23 · Tuscaloosa, ALFeb 7, 1965 · N4776P · Substantial damage NTSB UNK65X1377Accident · No injuriesClosedPiper PA24 · Gadsden, ALJan 31, 1965 · N7548P · Substantial damage NTSB UNK65X1284Accident · No injuriesClosedPiper PA-28 · Atmore, ALJan 13, 1965 · N6212W · Substantial damage NTSB UNK65X1275Accident · No injuriesClosedPiper PA-22 · Huntsville, ALJan 12, 1965 · N8727C · Substantial damage NTSB UNK65X1214Accident · No injuriesClosedBeechraft C18S · Ozark, ALJan 2, 1965 · N9189R · Substantial damage NTSB UNK65X1115Accident · Minor injuriesClosedMooney M20B · Goodwater, ALDec 24, 1964 · N74504 · Substantial damage NTSB UNK65X1098Accident · 1 fatalClosedCessna 175 · Leeds, ALDec 22, 1964 · N7086M · Substantial damage NTSB UNK65X0922Accident · No injuriesClosedPiper PA28 · Huntsville, ALDec 5, 1964 · N5581W · Substantial damage NTSB UNK65X0755Accident · No injuriesClosedPiper PA24 · Montgomery, ALNov 19, 1964 · N7812P · Substantial damage NTSB UNK65X0698Accident · No injuriesClosedCessna 150E · Tuscaloosa, ALNov 14, 1964 · N6197T · Substantial damage NTSB UNK65X0688Accident · No injuriesClosedCessna 120 · Russellville, ALNov 13, 1964 · N98538 · Substantial damage NTSB UNK65X0496Accident · No injuriesClosedCessna 172 · Theodore, ALOct 31, 1964 · N7426X · Substantial damage NTSB UNK65X0473Accident · No injuriesClosedBrewster FLEET1 · Mobile, ALOct 29, 1964 · N760V · Substantial damage NTSB UNK65X0429Accident · No injuriesClosedPiper PA28 · Fairhope, ALOct 25, 1964 · N6212W · Substantial damage NTSB UNK65X0339Accident · No injuriesClosedCessna 170B · Jasper, ALOct 19, 1964 · N3032A · Substantial damage NTSB UNK65X0326Accident · Minor injuriesClosedCurtis-Wght 12W · Gadsden, ALOct 18, 1964 · N418W · Destroyed NTSB UNK65X0290Accident · No injuriesClosedPiper PA28 · Bessemer, ALOct 16, 1964 · N6021W · Substantial damage