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 MIA78FA101Accident · 2 fatalClosedPiper PA-28R · Courtland, ALJul 1, 1978 · N47975 · Destroyed NTSB MIA78FA100Accident · 1 fatalClosedBeechcraft 65-80 · Mobile, ALJun 27, 1978 · N975SQ · Destroyed NTSB MIA78FA099Accident · No injuriesClosedBeech E18S · Birmingham, ALJun 26, 1978 · N5644D · Substantial damage NTSB MIA78FKJ55Accident · Minor injuriesClosedCessna 182 · Elberta, ALJun 25, 1978 · N6306B · Substantial damage NTSB MIA78FKJ54Accident · No injuriesClosedMaule M-4 · Brewton, ALJun 24, 1978 · N4130C · Substantial damage NTSB MIA78FKJ53Accident · Serious injuriesClosedBeech 100 · Muscle Shoals, ALJun 22, 1978 · N941K · Substantial damage NTSB MIA78DKJ50Accident · Minor injuriesClosedCessna 172 · Huntsville, ALJun 12, 1978 · N6136E · Substantial damage NTSB MIA78FKJ49Accident · No injuriesClosedCessna 150 · Auburn, ALJun 11, 1978 · N7195F · Substantial damage NTSB MIA78FKJ48Accident · No injuriesClosedGrumman G-164 · Elmore, ALJun 8, 1978 · N4778T · Substantial damage NTSB MIA78DKJ47Accident · No injuriesClosedBell 47G2 · Henagar, ALJun 5, 1978 · N12KH · Substantial damage NTSB MIA78FKJ41Accident · No injuriesClosedBeech D95A · Montgomery, ALMay 31, 1978 · N8965M · Substantial damage NTSB MIA78FKJ40Accident · No injuriesClosedCessna 172 · Chipley, ALMay 27, 1978 · N8374U · Substantial damage NTSB MIA78FA091Accident · 3 fatalClosedMooney M20C · Jackson, ALMay 26, 1978 · N7813V · Destroyed NTSB MIA78DKJ37Accident · No injuriesClosedPiper PA-34 · Eufaula, ALMay 22, 1978 · N577SA · Substantial damage NTSB MIA78DKJ36Accident · No injuriesClosedCessna 182 · Tuscaloosa, ALMay 20, 1978 · N52587 · Substantial damage NTSB MIA78FA079Incident · No injuriesClosedSwearingen 226-TC · Muscle Shoals, ALMay 8, 1978 · N70A · Minor damage NTSB MIA78FA077Accident · 2 fatalClosedHamilton T-28A · Huntsville, ALMay 6, 1978 · N3314G · Destroyed NTSB MIA78DKJ34Accident · No injuriesClosedCessna 182 · Gadsden, ALApr 29, 1978 · N8787T · Substantial damage NTSB MIA78DKJ35Accident · No injuriesClosedPiper PA-22 · Lacey Springs, ALApr 16, 1978 · N3553P · Substantial damage NTSB MIA78DKJ31Accident · No injuriesClosedCessna 177 · Alabaster, ALApr 9, 1978 · N13484 · Substantial damage NTSB MIA78DKJ30Accident · Minor injuriesClosedBellanca 7KCAB · Wetumpka, ALApr 9, 1978 · N1131E · Destroyed NTSB MIA78FKJ29Accident · No injuriesClosedEnstrom 280C · Smith Lake, ALApr 4, 1978 · N660H · Destroyed NTSB MIA78FKJ28Accident · No injuriesClosedBeech H18 · Birmingham, ALMar 29, 1978 · N787Q · Substantial damage NTSB MIA78FKJ26Accident · No injuriesClosedCessna 305 · Gainesville, ALMar 15, 1978 · N5223G · Substantial damage NTSB MIA78FKJ24Accident · No injuriesClosedCessna 421A · Muscle Shoals, ALMar 13, 1978 · N2245Q · Substantial damage NTSB MIA780KJ23Accident · No injuriesClosedPiper PA-18A · Ashland, ALFeb 25, 1978 · N9776D · Substantial damage NTSB MIA78FA037Accident · 1 fatalClosedCessna 402B · Tuscaloosa, ALFeb 1, 1978 · N8210Q · Destroyed NTSB MIA78DKJ20Accident · No injuriesClosedCessna 150 · Jacksonville, ALJan 31, 1978 · N714LQ · Substantial damage NTSB MIA78DKJ19Accident · No injuriesClosedMooney M20E · Gadsden, ALJan 8, 1978 · N7115U · Substantial damage NTSB MIA78FKJ18Accident · No injuriesClosedBeech D-55 · Mobile, ALJan 6, 1978 · N77DC · Substantial damage NTSB MIA78FA029Accident · 1 fatalClosedPiper PA-31 · Anniston, ALJan 6, 1978 · TIAFY · Destroyed NTSB MIA78DKJ16Accident · No injuriesClosedPiper PA-32R · Selma, ALDec 27, 1977 · N3570Q · Substantial damage NTSB MIA78DKJ15Accident · No injuriesClosedCessna 177B · Tuscaloosa, ALDec 23, 1977 · N18643 · Substantial damage NTSB MIA78AF019Accident · 1 fatalClosedCessna 150 · Dauphin Island, ALDec 17, 1977 · N6589T · Destroyed NTSB MIA78FKJI4Accident · No injuriesClosedCessna 421C · Bay Minette, ALDec 16, 1977 · N8305G · Substantial damage NTSB MIA78FKJ11Accident · Minor injuriesClosedCessna 177 · Scearcy, ALDec 4, 1977 · N76HS · Substantial damage NTSB MIA78FKJ08Accident · No injuriesClosedBeech A23 · Redhill, ALNov 29, 1977 · N8790M · Substantial damage NTSB MIA78DKJ10Accident · No injuriesClosedBeech J35 · Huntsville, ALNov 16, 1977 · N8318D · Substantial damage NTSB MIA78FA013Accident · 7 fatalClosedCessna 441 · Greensboro, ALNov 15, 1977 · N9971G · Destroyed NTSB MIA78DKJ07Accident · No injuriesClosedCessna 182 · Wetumpka, ALNov 15, 1977 · N1264S · Substantial damage NTSB MIA78FKJ05Accident · No injuriesClosedStinson 108-1 · Gurley, ALOct 30, 1977 · N9170K · Destroyed NTSB MIA78DKJ04Accident · No injuriesClosedGrum Amer AA1-B · Haleyville, ALOct 15, 1977 · N9943L · Substantial damage NTSB MIA78DKJ03Accident · No injuriesClosedBeech T34 · Headland, ALOct 15, 1977 · N10554 · Substantial damage NTSB MIA78DKJ01Accident · No injuriesClosedPiper PA28 · Toxey, ALOct 5, 1977 · N3293Q · Substantial damage NTSB MIA78DKJ02Accident · No injuriesClosedCessna 172P · Clanton, ALOct 4, 1977 · N4667K · Substantial damage NTSB MIA77FA093Accident · 1 fatalClosedBeech 100 · Auburn, ALSep 27, 1977 · N925BD · Destroyed NTSB MIA77FKJ83Accident · No injuriesClosedPiper PA-24 · Birmingham, ALSep 17, 1977 · N5779P · Substantial damage NTSB MIA78FKJ81Accident · No injuriesClosedCessna 172 · Grove Hill, ALSep 3, 1977 · N64260 · Minor damage NTSB MIA77FKJ80Accident · Minor injuriesClosedCessna 188 · Coosada, ALSep 3, 1977 · N3564Q · Destroyed NTSB MIA77FKJ88Accident · Serious injuriesClosedCessna 172 · Weaver, ALAug 31, 1977 · N8302B · Substantial damage