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 MIA74DKJ17Accident · No injuriesClosedCessna 206 · Mobile, ALAug 22, 1973 · N71223 · Substantial damage NTSB MIA74DKJ16Accident · No injuriesClosedPiper PA-34 · Huntsville, ALAug 19, 1973 · N2890T · Substantial damage NTSB MIA74DKJ15Accident · No injuriesClosedCessna 170A · Gadsden, ALAug 19, 1973 · N1619D · Substantial damage NTSB MIA74DKJ74Accident · No injuriesClosedCessna 150 · Ider, ALAug 13, 1973 · N60318 · Substantial damage NTSB MIA74DKJ13Accident · No injuriesClosedPiper PA-28 · Huntsville, ALAug 11, 1973 · N712FL · Substantial damage NTSB MIA74FKJ11Accident · 1 fatalClosedPiper PA-25 · Trinity, ALAug 6, 1973 · N7432Z · Destroyed NTSB MIA74DKJ10Accident · No injuriesClosedPiper PA-28 · Wetumpka, ALAug 5, 1973 · N95357 · Substantial damage NTSB MIA74DKJ09Accident · No injuriesClosedCessna 150C · Arley, ALAug 3, 1973 · N6246T · Substantial damage NTSB MIA74DKJ08Accident · Minor injuriesClosedPiper PA-25 · Millers Ferry, ALAug 1, 1973 · N6499Z · Substantial damage NTSB MIA74DKJ07Accident · No injuriesClosedCessna 172 · Andalusa, ALJul 28, 1973 · N20234 · Substantial damage NTSB MIA74DKJ05Accident · No injuriesClosedPiper PA-23 · Huntsville, ALJul 27, 1973 · N5894Y · Substantial damage NTSB MIA73DKJ04Accident · No injuriesClosedBellanca 17-31A · Courtland, ALJul 25, 1973 · N6585V · Substantial damage NTSB MIA74AM003Accident · 1 fatalClosedCessna 150L · Wicksburg, ALJul 11, 1973 · N7007X · Destroyed NTSB MIA74DKJ02Accident · No injuriesClosedBeech D50E · Muscle Shoals, ALJul 8, 1973 · N460T · Substantial damage NTSB MIA74DKJ01Accident · No injuriesClosedBensen B8M · Montgomery, ALJul 1, 1973 · N3704 · Substantial damage NTSB MIA73DKJ74Accident · No injuriesClosedChampion 7GCA · Hazel Green, ALJun 29, 1973 · N9529S · Substantial damage NTSB MIA73DKJ72Accident · No injuriesClosedCessna 150H · Weaver, ALJun 29, 1973 · N22016 · Substantial damage NTSB MIA73FKJ71Accident · Serious injuriesClosedRyan ST-3KR · Wetumpka, ALJun 23, 1973 · N5246 · Substantial damage NTSB MIA73DKJ73Accident · No injuriesClosedCessna 411 · Tuscaloosa, ALJun 23, 1973 · N49BC · Substantial damage NTSB MIA73DKJ70Accident · Minor injuriesClosedCessna 188 · Florence, ALJun 21, 1973 · N8087V · Destroyed NTSB MIA73FKJ69Accident · No injuriesClosedBeech 95-B55 · Dothan, ALJun 18, 1973 · N7098N · Substantial damage NTSB MIA73DKJ68Accident · No injuriesClosedPiper PA-30 · Greenville, ALJun 9, 1973 · N8643Y · Substantial damage NTSB MIA73DKJ66Accident · No injuriesClosedBeech 95-55 · Mobile, ALJun 6, 1973 · N8933M · Substantial damage NTSB MIA73DKJ67Accident · No injuriesClosedPiper PA-12 · Brownsboro, ALJun 3, 1973 · N2849M · Substantial damage NTSB MIA73DKJ65Accident · No injuriesClosedCessna 172H · Birmingham, ALJun 3, 1973 · N3824R · Substantial damage NTSB MIA73AM105Accident · 1 fatalClosedCessna 140A · Burkville, ALJun 2, 1973 · N3798V · Destroyed NTSB MIA73DKJ63Accident · Minor injuriesClosedMooney M20E · Camden, ALMay 27, 1973 · N6922U · Substantial damage NTSB MIA73FKJ61Accident · Serious injuriesClosedCessna 188B · Talladega, ALMay 24, 1973 · N9985G · Destroyed NTSB MIA73DKJ62Accident · No injuriesClosedPiper PA-30 · Fairhope, ALMay 24, 1973 · N8402Y · Substantial damage NTSB MIA73DKJ60Accident · Minor injuriesClosedCessna 150H · Hazel Green, ALMay 21, 1973 · N22159 · Substantial damage NTSB MIA73DKJ59Accident · Serious injuriesClosedCessna 150 · Talledega, ALMay 15, 1973 · N6604G · Destroyed NTSB MIA73AM101Accident · 2 fatalClosedPiper PA-28 · Troy, ALMay 12, 1973 · N9551W · Destroyed NTSB MIA73DKJ64Accident · No injuriesClosedCessna 182 · Birmingham, ALMay 11, 1973 · N5518B · Substantial damage NTSB MIA73FKJ55Accident · Minor injuriesClosedAmer Avco AA1 · Jasper, ALMay 10, 1973 · ZS-IXE · Substantial damage NTSB MIA73DKJ56Accident · No injuriesClosedPiper PA-25 · Mccullough, ALMay 10, 1973 · N7716Z · Substantial damage NTSB MIA73FKJ54Accident · No injuriesClosedMaule M4-220 · Tuskegee, ALMay 9, 1973 · N9865M · Substantial damage NTSB MIA73FKJ53Accident · 2 fatalClosedLockheed PV-1 · Union Springs, ALMay 4, 1973 · N45CK · Destroyed NTSB MIA73DKJ58Accident · No injuriesClosedAero Comdr 600S2C · Camden, ALMay 1, 1973 · N5598X · Substantial damage NTSB MIA73FKJ52Accident · No injuriesClosedCessna 150 · Coden, ALApr 27, 1973 · N6611S · Substantial damage NTSB MIA73FKJ57Accident · No injuriesClosedBreezy TB-1 · Wetumpka, ALApr 22, 1973 · N429RT · Substantial damage NTSB MIA73DKJ51Accident · No injuriesClosedPiper PA-22 · Pell City, ALApr 17, 1973 · N4448A · Destroyed NTSB MIA73FKJ50Accident · Serious injuriesClosedAero Comdr 560A · Midway, ALApr 4, 1973 · N2668B · Destroyed NTSB MIA73DKJ49Accident · No injuriesClosedStinson 108 · Wetumpka, ALMar 28, 1973 · N97546 · Substantial damage NTSB IAD73A1006Accident · 2 fatalClosedPiper J3 · Brundidge, ALMar 24, 1973 · N98633 · Destroyed NTSB IAD73AI004Accident · 1 fatalClosedPiper PA-28 · Oneonta, ALMar 22, 1973 · N9882W · Destroyed NTSB MIA73DKJ48Accident · Serious injuriesClosedMooney M20-C · Bay Minette, ALMar 21, 1973 · N6797U · Substantial damage NTSB MIA73AM092Accident · 1 fatalClosedCessna 177RG · Huntsville, ALMar 16, 1973 · N1828Q · Destroyed NTSB MIA73DKJ46Accident · No injuriesClosedCessna 172 · Daleville, ALMar 15, 1973 · N8721U · Substantial damage NTSB MIA73AM091Accident · 2 fatalClosedLuscombe 8A · Greensboro, ALMar 14, 1973 · N71509 · Destroyed NTSB MIA73FKJ45Accident · No injuriesClosedBeech A23-19 · Opelika, ALMar 10, 1973 · N14BW · Substantial damage