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 MIA66D0436Accident · No injuriesClosedBeechcraft C35 · Hazelgreen, ALDec 19, 1965 · N1882D · Substantial damage NTSB MIA66A0066Accident · 1 fatalClosedCessna 172B · Oneonta, ALDec 12, 1965 · N7543X · Destroyed NTSB MIA66D0391Accident · No injuriesClosedBeech E35 · Aliceville, ALDec 8, 1965 · N5810C · Substantial damage NTSB MIA66D0368Accident · No injuriesClosedPiper PA-28 · Muscle Shoals, ALDec 2, 1965 · N5542W · Substantial damage NTSB MIA66D0371Accident · No injuriesClosedCessna 210 · Owens Cross R, ALNov 30, 1965 · N9429T · Substantial damage NTSB MIA66D0427Accident · No injuriesClosedPiper PA-24 · Grove Hill, ALNov 27, 1965 · N6523P · Substantial damage NTSB MIA66F0364Accident · No injuriesClosedPiper PA-28 · Camden, ALNov 25, 1965 · N5423W · Substantial damage NTSB MIA66D0396Accident · No injuriesClosedPiper PA-23 · Haleyville, ALNov 22, 1965 · N4926F · Substantial damage NTSB MIA66F0370Accident · No injuriesClosedPiper PA-28 · Huntsville, ALNov 10, 1965 · N5866W · Substantial damage NTSB MIA66F0326Accident · Serious injuriesClosedUniv Acft D-16A · Gainestown, ALNov 8, 1965 · N703T · Destroyed NTSB MIA66F0288Accident · Minor injuriesClosedPiper PA-11 · Clanton, ALOct 31, 1965 · N4727H · Substantial damage NTSB MIA49A0049Accident · 2 fatalClosedTaylorcraft BF-12 · Horton, ALOct 30, 1965 · N33957 · Destroyed NTSB MIA66F0369Accident · No injuriesClosedCessna 150E · Theodore, ALOct 24, 1965 · N3082J · Substantial damage NTSB MIA66D0359Accident · No injuriesClosedCessna 172 · Aliceville, ALOct 17, 1965 · N8385B · Substantial damage NTSB MIA66A0044Accident · Minor injuriesClosedDouglas DC-6 · Huntsville, ALOct 17, 1965 · N37519 · Substantial damage NTSB MIA66F0298Accident · No injuriesClosedLockheed T-33 · Montgomery, ALOct 12, 1965 · AF80632 · 2 aircraft · Substantial damage NTSB MIA66F0363Accident · No injuriesClosedPiper PA-23 · Mobile, ALOct 8, 1965 · N3486P · Substantial damage NTSB MIA66F0310Accident · No injuriesClosedPiper PA-22 · Sterrett, ALOct 2, 1965 · N5744Z · Substantial damage NTSB MIA66A0038Accident · 1 fatalClosedCessba 140 · Trenton, ALOct 1, 1965 · N77409 · Destroyed NTSB MIA66D0273Accident · No injuriesClosedErcoupe 415-C · Sylacauga, ALSep 26, 1965 · N87272 · Substantial damage NTSB MIA66D0349Accident · No injuriesClosedBeechcraft H-50 · Montgomery, ALSep 24, 1965 · N126WP · Substantial damage NTSB MIA66F0274Accident · Serious injuriesClosedAeronca 11AC · Oneonta, ALSep 22, 1965 · N8605 · Substantial damage NTSB MIA66F0262Accident · Minor injuriesClosedPiper PA-22 · Jasper, ALSep 18, 1965 · N2943Z · Destroyed NTSB MIA66F0257Accident · Minor injuriesClosedCessna 150 · Birmingham, ALSep 16, 1965 · N8667S · Destroyed NTSB MIA66F0226Accident · No injuriesClosedPiper PA-18 · Centre, ALSep 14, 1965 · N140T · Destroyed NTSB MIA66F0205Accident · No injuriesClosedPiper PA-18A · Wing, ALSep 14, 1965 · N4703A · Substantial damage NTSB MIA66D0198Accident · No injuriesClosedCessna 150 · Birmingham, ALSep 13, 1965 · N3987U · Substantial damage NTSB MIA66F0232Accident · Serious injuriesClosedL.Kauffman LK10A · Harvest, ALSep 12, 1965 · N56300 · Substantial damage NTSB MIA66F0213Accident · Serious injuriesClosedCessna 120 · Holtville, ALSep 12, 1965 · N76185 · Substantial damage NTSB MIA66F0212Accident · No injuriesClosedPiper PA-25 · Florala, ALSep 12, 1965 · N6789Z · Substantial damage NTSB MIA66F0249Accident · No injuriesClosedPiper PA-18 · Jefferson, ALSep 2, 1965 · N3292Z · Substantial damage NTSB MIA66F0260Accident · No injuriesClosedPiper PA-30 · Mobile, ALSep 1, 1965 · N7025Y · Substantial damage NTSB MIA66F0250Accident · No injuriesClosedBoeing A-75N1 · Huntsville, ALAug 25, 1965 · N55134 · Substantial damage NTSB MIA66F0216Accident · No injuriesClosedPiper PA-23 · Mobile, ALAug 25, 1965 · N4300Y · Substantial damage NTSB MIA66F0196Accident · No injuriesClosedPiper PA-25 · Moundville, ALAug 23, 1965 · N7245Z · Substantial damage NTSB MIA66D0195Accident · No injuriesClosedPiper PA-28 · Huntsville, ALAug 17, 1965 · N6666W · Substantial damage NTSB MIA66F0175Accident · No injuriesClosedPiper PA-22 · Slocomb, ALAug 15, 1965 · N7059D · Destroyed NTSB MIA66A0020Accident · 1 fatalClosedTaylorcraft BC12-D · Selma, ALAug 14, 1965 · N96729 · Substantial damage NTSB MIA66F0225Accident · No injuriesClosedPiper PA-30 · Birmingham, ALAug 13, 1965 · N7602Y · Substantial damage NTSB MIA66F0193Accident · Minor injuriesClosedPiper J-3 · Elba, ALAug 9, 1965 · N35301 · Substantial damage NTSB MIA66D0191Accident · No injuriesClosedAeronca 7EC · Centreville, ALAug 7, 1965 · N7482B · Substantial damage NTSB MIA66F0118Accident · No injuriesClosedPiper PA-28 · Selma, ALAug 3, 1965 · N5880W · Substantial damage NTSB MIAL6F0115Accident · No injuriesClosedCessna 310 · Greensboro, ALJul 30, 1965 · N192R · Substantial damage NTSB MIA66F0176Accident · Minor injuriesClosedCallair A-9 · Sardis, ALJul 30, 1965 · N8265H · Destroyed NTSB MIA66A0017Accident · 1 fatalClosedPiper PA-18 · Gordon, ALJul 28, 1965 · N2208A · Destroyed NTSB MIA66F0177Accident · No injuriesClosedPiper PA-24 · Clanton, ALJul 26, 1965 · N6502P · Substantial damage NTSB MIA66A0014Accident · 1 fatalClosedPiper PA-24 · Parrish, ALJul 24, 1965 · N8616P · Destroyed NTSB MIA66F0068Accident · No injuriesClosedPiper PA-18 · Vernon, ALJul 21, 1965 · N3853Z · Substantial damage NTSB MIA66F0067Accident · Minor injuriesClosedPiper PA-25 · Burnt Corn, ALJul 21, 1965 · N7139Z · Destroyed NTSB MIA66D0190Accident · Serious injuriesClosedAeronca 7AC · Courtland, ALJul 16, 1965 · N2347E · Destroyed