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 MIA77DKJ24Accident · No injuriesClosedHelton Lark 95 · Selma, ALMar 24, 1977 · N5016J · Substantial damage NTSB MIA77FKJ23Accident · Serious injuriesClosedGrum Amer AA5 · Gadsden, ALMar 21, 1977 · N5470L · Destroyed NTSB MIA77DKJ22Accident · No injuriesClosedPiper PA-28 · Fort Payne, ALMar 20, 1977 · N6456R · Substantial damage NTSB MIA77FKJ21Accident · 1 fatalClosedBellanca 8KCAB · Headland, ALMar 15, 1977 · N57479 · Destroyed NTSB MIA77FKJ20Accident · Serious injuriesClosedCessna 150L · Tuscumbia, ALMar 4, 1977 · N7785G · Destroyed NTSB MIA77DKJ19Accident · No injuriesClosedStinson 108-1 · Bay Minette, ALFeb 20, 1977 · N9183K · Substantial damage NTSB MIA77FKJ17Accident · No injuriesClosedPiper PA-32 · Elberta, ALFeb 13, 1977 · N5246S · Substantial damage NTSB MIA77DKJ18Accident · No injuriesClosedCessna 150 · Mount Olive, ALFeb 11, 1977 · N6673T · Substantial damage NTSB MIA77DKJ16Accident · No injuriesClosedBellanca 7KCAB · Enterprise, ALFeb 6, 1977 · N53805 · Substantial damage NTSB MIA77DKJ15Accident · No injuriesClosedCessna 170 · Gadsden, ALFeb 5, 1977 · N1619D · Substantial damage NTSB MIA77DKJ13Accident · No injuriesClosedPiper PA-23C · Enterprise, ALJan 26, 1977 · N6293Y · Substantial damage NTSB MIA77DKJ12Accident · No injuriesClosedPiper PA-28 · Wetumpka, ALJan 16, 1977 · N5537F · Substantial damage NTSB MIA77DKJ11Accident · No injuriesClosedPiper PA-24 · Gadsden, ALJan 1, 1977 · N7507P · Substantial damage NTSB MIA77FKJ10Accident · No injuriesClosedPiper PA-24 · Birmingham, ALDec 16, 1976 · N2172M · Substantial damage NTSB MIA77FKJ08Accident · No injuriesClosedMitsubishi MU-2B · Gadsden, ALDec 3, 1976 · N304L · Substantial damage NTSB MIA77DKJ06Accident · Minor injuriesClosedCessna 150 · Eufaula, ALNov 26, 1976 · N8363J · Substantial damage NTSB MIA77DA011Accident · No injuriesClosedPiper PA-24 · Birmington, ALNov 23, 1976 · N8902P · Substantial damage NTSB MIA77FKJ04Accident · No injuriesClosedPiper PA-34 · Selma, ALOct 29, 1976 · N4484T · Substantial damage NTSB MIA77FKJ03Accident · Serious injuriesClosedCessna 150 · New Brockton, ALOct 25, 1976 · N802AA · Substantial damage NTSB MIA77DKJ05Accident · No injuriesClosedBoeing 75 · Montgomery, ALOct 13, 1976 · N75869 · Substantial damage NTSB MIA77DKJ02Accident · No injuriesClosedAero Comdr 690A · Fayette, ALOct 13, 1976 · N123G · Substantial damage NTSB MIA77FKJ01Accident · 1 fatalClosedGrumman G-164 · Pansey, ALOct 2, 1976 · N23RA · Destroyed NTSB MIA76FKK04Accident · No injuriesClosedCessna 150 · Pell City, ALSep 21, 1976 · N5970G · Destroyed NTSB MIA76DKK03Accident · No injuriesClosedPiper PA-23 · Demopolis, ALSep 16, 1976 · N62569 · Substantial damage NTSB MIA76DKK02Accident · No injuriesClosedGrumman G-164A · Ashford, ALSep 9, 1976 · N9936 · Substantial damage NTSB MIA76DKK01Accident · No injuriesClosedCessna 188 · Huntsville, ALSep 6, 1976 · N5606J · Destroyed NTSB MIA76FKJ99Accident · Minor injuriesClosedHiller UH-12B · Midland City, ALSep 5, 1976 · N47091 · Destroyed NTSB MIA76AM107Accident · 3 fatalClosedCessna T210G · Brantley, ALSep 4, 1976 · N6826R · Destroyed NTSB MIA76FKJ97Accident · 1 fatalClosedAero-Comdr 600S2R · Ashland, ALAug 30, 1976 · N5652X · 2 aircraft · No damage NTSB MIA76DKJ98Accident · No injuriesClosedBiplane EAA · Talladega, ALAug 29, 1976 · N52RZ · Substantial damage NTSB MIA76FKJ96Accident · Minor injuriesClosedPiper J5A · Bessemer, ALAug 23, 1976 · N38027 · Substantial damage NTSB MIA76FKJ95Accident · No injuriesClosedPiper PA-18 · Birmingham, ALAug 21, 1976 · N222T · Substantial damage NTSB MIA76DKJ94Accident · No injuriesClosedBoeing A75N1 · Headland.Al, ALAug 20, 1976 · N3965B · Substantial damage NTSB MIA76FKJ92Accident · 1 fatalClosedPiper PA-25 · Flomaton, ALAug 14, 1976 · N9517P · Substantial damage NTSB MIA76FKJ93Accident · No injuriesClosedCessna 188 · Geneva, ALAug 11, 1976 · N9829V · Substantial damage NTSB MIA76FKJ90Accident · No injuriesClosedTed Smith 601 · Eufaula, ALAug 5, 1976 · N27HA · Substantial damage NTSB MIA76DKJ91Accident · No injuriesClosedCessna 210L · Mobile, ALAug 5, 1976 · N2226S · Substantial damage NTSB MIA76DKJ89Accident · No injuriesClosedPiper PA-28 · Talladega, ALJul 29, 1976 · N5738U · Substantial damage NTSB MIA76DKJ87Accident · No injuriesClosedAero Comdr A-9B · Ozark, ALJul 28, 1976 · N7952V · Substantial damage NTSB MIA76DKJ86Accident · No injuriesClosedBell 47D1 · Centre, ALJul 24, 1976 · N29WL · Destroyed NTSB MIA76DKJ85Accident · Minor injuriesClosedCessna 150M · Russellville, ALJul 24, 1976 · N63476 · Substantial damage NTSB MIA76DKJ84Accident · No injuriesClosedMooney M20 · Huntsville, ALJul 23, 1976 · N74759 · Substantial damage NTSB MIA76DKJ88Accident · No injuriesClosedCessna 150 · Hazel Green, ALJul 19, 1976 · N5297Q · Substantial damage NTSB MIA76DKJ83Accident · No injuriesClosedCessna 305A · Huntsville, ALJul 17, 1976 · N64836 · Substantial damage NTSB MIA76FKJ81Accident · No injuriesClosedPiper PA-23 · Mobile, ALJul 8, 1976 · N16442 · Substantial damage NTSB MIA76FKJ79Accident · No injuriesClosedCessna 188 · Enterprise, ALJul 6, 1976 · N5517S · Substantial damage NTSB MIA76DKJ80Accident · No injuriesClosedPiper PA-34 · Harvest, ALJul 4, 1976 · N9303K · Substantial damage NTSB MIA76DKJ78Accident · Serious injuriesClosedBoeing E-75 · Headland, ALJul 1, 1976 · N65949 · Substantial damage NTSB MIA76DKJ77Accident · Minor injuriesClosedBell 47G-4 · Natural Bridge, ALJun 28, 1976 · N1216W · Substantial damage NTSB MIA76DKJ76Accident · No injuriesClosedCessna 177A · Geneva, ALJun 21, 1976 · N30564 · Substantial damage