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 MIA77DKJ79Accident · No injuriesClosedPiper PA-25 · Mccullough, ALAug 25, 1977 · N7509Z · Substantial damage NTSB MIA77DKJ78Accident · No injuriesClosedAero Comdr A9 · Berry, ALAug 21, 1977 · N7291V · Substantial damage NTSB MIA77DKJ77Accident · No injuriesClosedHughes 269A · Clanton, ALAug 21, 1977 · N8877F · Substantial damage NTSB MIA77FKJ76Accident · 1 fatalClosedPiper PA-25 · Castleberry, ALAug 20, 1977 · N4622Y · Destroyed NTSB MIA77DKJ75Accident · Minor injuriesClosedBellanca 1730 · Dauphin Is, ALAug 17, 1977 · N7324V · Substantial damage NTSB MIA77DKJ74Accident · No injuriesClosedPiper PA-25 · Ashford, ALAug 16, 1977 · N4960Y · Substantial damage NTSB MIA77DKJ73Accident · Minor injuriesClosedPiper PA-18 · Cullman, ALAug 16, 1977 · N8176C · Substantial damage NTSB MIA77FKJ69Accident · 1 fatalClosedPiper PA-18 · Vincent, ALAug 15, 1977 · N4731A · Destroyed NTSB MIA77DKJ70Accident · Minor injuriesClosedBoeing E75 · Mexia, ALAug 15, 1977 · N4850N · Substantial damage NTSB MIA77FKJ68Accident · No injuriesClosedCessna 195 · Dothan, ALAug 14, 1977 · N195GN · Substantial damage NTSB MIA77DKJ67Accident · Minor injuriesClosedBeech C-23 · Montgomery, ALAug 13, 1977 · N18766 · Substantial damage NTSB MIA77DKJ72Accident · No injuriesClosedPiper PA-30 · Montgomery, ALAug 12, 1977 · N7555Y · Substantial damage NTSB MIA77DKJ71Accident · No injuriesClosedHughes 269A1 · Mt.Meigs, ALAug 11, 1977 · N8897F · Substantial damage NTSB MIA77DKJ65Accident · No injuriesClosedBell 47D1 · New Brockton, ALAug 6, 1977 · N8282 · Substantial damage NTSB MIA77DKJ64Accident · Minor injuriesClosedRockwell S2R · Bay Minette, ALAug 6, 1977 · N8942Q · Substantial damage NTSB MIA77DKJ66Accident · No injuriesClosedBeech 58 · Centerville, ALAug 5, 1977 · N21BW · Substantial damage NTSB MIA77FKJ63Accident · No injuriesClosedAero Comdr A9 · Samson, ALAug 4, 1977 · N7284V · Substantial damage NTSB MIA77FKJ54Accident · No injuriesClosedCessna 182 · Foley, ALAug 1, 1977 · N2378R · Destroyed NTSB MIA77DKJ62Accident · Serious injuriesClosedEnstrom F28 · Montgomery, ALJul 31, 1977 · N2950 · Substantial damage NTSB MIA77FA072Accident · 3 fatalClosedPiper PA-32 · Clanton, ALJul 29, 1977 · N8663N · Destroyed NTSB MIA77FKJ61Accident · No injuriesClosedPiper PA-23 · Montgomery, ALJul 27, 1977 · N1908T · Substantial damage NTSB MIA77FKJ60Accident · No injuriesClosedCessna 177RG · Weaver, ALJul 26, 1977 · N33273 · Substantial damage NTSB MIA77FA067Accident · 2 fatalClosedBellanca 7KCAB · Elberta, ALJul 14, 1977 · N87045 · Destroyed NTSB MIA77DKJ57Accident · No injuriesClosedPiper PA18 · Alabaster, ALJul 9, 1977 · N221T · Substantial damage NTSB MIA77FKJ56Accident · Serious injuriesClosedBeech C18S · Irvington, ALJul 4, 1977 · N711SM · Substantial damage NTSB MIA77FKJ55Accident · Minor injuriesClosedCessna 177G · Monroeville, ALJul 4, 1977 · N35869 · Substantial damage NTSB MIA77FKJ53Accident · No injuriesClosedPiper PA-18 · Riverside, ALJun 29, 1977 · N9115D · Substantial damage NTSB MIA77FA065Accident · 1 fatalClosedPiper PA18 · Foley, ALJun 26, 1977 · N9578D · Destroyed NTSB MIA77DKJ51Accident · No injuriesClosedCessna 150H · Birmingham, ALJun 25, 1977 · N6470S · Substantial damage NTSB MIA77FKJ50Accident · Minor injuriesClosedPiper PA-28 · Talladega, ALJun 24, 1977 · N75041 · Substantial damage NTSB MIA77FKJ48Accident · No injuriesClosedCessna 150 · Gordon, ALJun 20, 1977 · N704JZ · Substantial damage NTSB MIA77FKJ46Accident · No injuriesClosedBeech D18 · Sylacauga, ALJun 19, 1977 · N413TB · Minor damage NTSB MIA77DKJ47Accident · No injuriesClosedBeech B19 · Birmingham, ALJun 12, 1977 · N59BW · Substantial damage NTSB MIA77DKJ45Accident · No injuriesClosedCessna 182 · Huntsville, ALJun 6, 1977 · N6409A · Substantial damage NTSB MIA77FKJ42Accident · No injuriesClosedBeech H35 · Bessemer, ALJun 4, 1977 · N7989D · Substantial damage NTSB MIA77FKJ43Accident · Serious injuriesClosedBellanca 8GCBC · Foley, ALJun 2, 1977 · N7626S · Destroyed NTSB MIA77FKJ44Accident · No injuriesClosedGrumman G-164A · Centreville, ALJun 1, 1977 · N4824 · Substantial damage NTSB MIA77DKJ40Accident · No injuriesClosedCessna 150 · Tuscaloosa, ALMay 29, 1977 · N9234U · Substantial damage NTSB MIA77FKJ38Accident · No injuriesClosedCessna 150 · Ashland, ALMay 18, 1977 · N45197 · Substantial damage NTSB MIA77DKJ37Accident · No injuriesClosedBell 47D1 · Ozark, ALMay 15, 1977 · N74898 · Substantial damage NTSB MIA77FKJ36Accident · No injuriesClosedCessna 150 · Hazel Green, ALMay 10, 1977 · N7297Q · Substantial damage NTSB MIA77DKJ35Accident · No injuriesClosedCessna 180 · Darlington, ALApr 27, 1977 · N7831K · Substantial damage NTSB MIA77FKJ34Accident · No injuriesClosedHughes 269C · Clanton, ALApr 20, 1977 · N9636F · Substantial damage NTSB MIA77DKJ32Accident · No injuriesClosedCessna 150 · Holtville, ALApr 17, 1977 · N18645 · Substantial damage NTSB MIA77FKJ30Accident · Minor injuriesClosedPiper J3 · Graysville, ALApr 16, 1977 · N30451 · Substantial damage NTSB MIA77DKJ31Accident · Serious injuriesClosedPiper J-3 · Mobile, ALApr 16, 1977 · N65881 · Substantial damage NTSB MIA77FKJ29Accident · No injuriesClosedAerospatle SA315B · Mcintosh, ALApr 13, 1977 · N90824 · Substantial damage NTSB MIA77DKJ27Accident · No injuriesClosedPiper PA-28 · Tuscaloosa, ALApr 7, 1977 · N9538W · Minor damage NTSB MIA77FKJ26Accident · No injuriesClosedPiper PA-30 · Tuscaloosa, ALApr 6, 1977 · N8800Y · Substantial damage NTSB MIA77DKJ25Accident · No injuriesClosedLuscombe 8A · Moundville, ALApr 4, 1977 · N1609K · Substantial damage