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 MIA69F0099Accident · Minor injuriesClosedPiper PA-25 · Eufala, ALJul 27, 1968 · N4908Y · Destroyed NTSB MIA69D0075Accident · No injuriesClosedCessna 180 · Alexander Cty, ALJul 19, 1968 · N4971A · 2 aircraft · Minor damage NTSB MIA69D0158Accident · No injuriesClosedCessna 150 · Mt.Vernon, ALJul 18, 1968 · N2423J · Substantial damage NTSB MIA69F0063Accident · No injuriesClosedBoeing A75N1 · Clanton, ALJul 13, 1968 · N55530 · Substantial damage NTSB MIA69F0094Accident · No injuriesClosedBeech 35-B33 · Montgomery, ALJul 4, 1968 · N513AA · Substantial damage NTSB MIA69F0061Accident · Serious injuriesClosedPiper PA-25 · Clanton, ALJul 4, 1968 · N7149Z · Destroyed NTSB MIA69D0044Accident · No injuriesClosedBeech J35 · Clanton, ALJul 4, 1968 · N8309D · Substantial damage NTSB MIA69D0025Accident · Minor injuriesClosedPiper J-5 · Brownsboro, ALJul 4, 1968 · N30924 · Substantial damage NTSB MIA69D0034Accident · No injuriesClosedPiper PA-28 · Decatur, ALJun 27, 1968 · N6321R · Substantial damage NTSB MIA69D0031Accident · No injuriesClosedPiper PA-18 · Montgomery, ALJun 25, 1968 · N1956A · Substantial damage NTSB MIA69F0028Accident · No injuriesClosedPiper PA-22 · Scottsboro, ALJun 20, 1968 · N4970Z · 2 aircraft · Substantial damage NTSB MIA69F0040Accident · Minor injuriesClosedFlaglor II · Gadsden, ALJun 17, 1968 · N12042 · Substantial damage NTSB MIA69D0026Accident · No injuriesClosedCessna 182 · Hurtsboro, ALJun 13, 1968 · N6374A · Substantial damage NTSB MIA68A0104Accident · Minor injuriesClosedCessna 150F · Irvington, ALJun 9, 1968 · N8853S · Substantial damage NTSB MIA68F0542Accident · No injuriesClosedPiper PA-30 · Birmingham, ALJun 8, 1968 · N7474Y · Substantial damage NTSB MIA68A0103Accident · 2 fatalClosedPiper J3C-65 · Montgomery, ALJun 8, 1968 · N65886 · Substantial damage NTSB MIA68D0544Accident · No injuriesClosedPiper PA-28 · Madison, ALJun 6, 1968 · N1748J · Substantial damage NTSB MIA68F0531Accident · No injuriesClosedPiper PA-28 · Gadsden, ALMay 31, 1968 · N5828W · Substantial damage NTSB MIA68F0543Accident · Serious injuriesClosedCessna 140 · Brownsboro, ALMay 30, 1968 · N1895V · Substantial damage NTSB MIA68F0540Accident · Minor injuriesClosedSchempp SHK · Brownsboro, ALMay 30, 1968 · N801M · Substantial damage NTSB MIA69F0001Accident · No injuriesClosedCessna 150G · Geraldine, ALMay 28, 1968 · N3196J · Substantial damage NTSB MIA69F0039Accident · No injuriesClosedAero Comdr 520 · Geiger, ALMay 21, 1968 · N2604B · Substantial damage NTSB MIA68F0538Accident · Serious injuriesClosedCessna 172 · Thomaston, ALMay 19, 1968 · N5810R · Destroyed NTSB MIA68F0533Accident · No injuriesClosedCessna 150 · Montgomery, ALMay 15, 1968 · N7126X · Destroyed NTSB MIA68F0541Accident · Serious injuriesClosedPiper PA-25 · Atmore, ALMay 14, 1968 · N6250Z · Destroyed NTSB MIA68D0520Accident · No injuriesClosedCessna 172 · Gordo, ALMay 8, 1968 · N5811R · Substantial damage NTSB MIA68D0524Accident · No injuriesClosedCessna 206 · Ft Rucker, ALApr 21, 1968 · N3953G · Substantial damage NTSB MIA68D0495Accident · No injuriesClosedPiper PA-25 · Whitehall, ALApr 8, 1968 · N6657Z · Substantial damage NTSB MIA68F0455Accident · No injuriesClosedPiper PA-24 · Selma, ALMar 26, 1968 · N7348P · Substantial damage NTSB MIA68A0075Accident · 1 fatalClosedBeech 35 · Troy, ALMar 9, 1968 · N5148C · Destroyed NTSB MIA68F0428Accident · No injuriesClosedMooney M20E · Gadsden, ALFeb 24, 1968 · N7197U · Substantial damage NTSB MIA68D0414Accident · No injuriesClosedBeech 23 · Greensboro, ALFeb 20, 1968 · N2304L · Substantial damage NTSB MIA68A0068Accident · 3 fatalClosedCessna 182 · Calera, ALFeb 17, 1968 · N2671F · Destroyed NTSB MIA68F0409Accident · No injuriesClosedCessna 411 · Jasper, ALFeb 15, 1968 · N7382U · Substantial damage NTSB MIA68D0433Accident · No injuriesClosedAeronca 7AC · Gadsden, ALFeb 15, 1968 · N82408 · Substantial damage NTSB MIA68D0446Accident · No injuriesClosedBeech B95A · Mobile, ALFeb 10, 1968 · N190PF · Substantial damage NTSB MIA68A0065Accident · 2 fatalClosedBeech B95 · Marion, ALJan 28, 1968 · N9712Y · Destroyed NTSB MIA68D0384Accident · No injuriesClosedTaylorcraft BC12-D · Oak Grove, ALJan 21, 1968 · N95779 · Substantial damage NTSB MIA68F0408Accident · No injuriesClosedCessna 310K · Guntersville, ALJan 13, 1968 · N7023L · Substantial damage NTSB MIA68A0061Accident · 3 fatalClosedMooney M20C · Eastaboga, ALJan 3, 1968 · N1356W · Destroyed NTSB MIA68D0344Accident · No injuriesClosedCessna 182 · Anniston, ALJan 1, 1968 · N2308X · Substantial damage NTSB MIA68D0424Accident · No injuriesClosedPiper PA-32 · Eufala, ALDec 25, 1967 · N3936W · Substantial damage NTSB MIA68F0351Accident · No injuriesClosedBeech 23 · Birmingham, ALDec 22, 1967 · N2374L · Substantial damage NTSB MIA68F0347Accident · Minor injuriesClosedCessna 210 · Bay Minette, ALDec 19, 1967 · N4803U · Substantial damage NTSB MIA68D0369Accident · No injuriesClosedCessna 150 · Pell City, ALDec 16, 1967 · N3316J · Substantial damage NTSB MIA68F0307Accident · No injuriesClosedAero Comdr 680 · Decatur, ALDec 12, 1967 · N8302 · Substantial damage NTSB MIA68D0366Accident · No injuriesClosedCessna 182 · Dothan, ALDec 9, 1967 · N3514F · Substantial damage NTSB MIA68D0328Accident · No injuriesClosedPiper PA-30 · Dothan, ALNov 25, 1967 · N7026Y · Substantial damage NTSB MIA68D0345Accident · No injuriesClosedBeech 35-33 · Mobile, ALNov 24, 1967 · N13232 · Substantial damage NTSB MIA68A0049Accident · 1 fatalClosedPiper PA-30 · Oxford, ALNov 21, 1967 · N8124Y · Destroyed