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 MIA69F0472Accident · No injuriesClosedBeech A23-19 · Birmingham, ALMay 9, 1969 · N7625R · Substantial damage NTSB MIA69D0445Accident · No injuriesClosedBeech E18S · Geiger, ALMay 8, 1969 · N4906B · Substantial damage NTSB MIA69D0449Accident · No injuriesClosedPiper PA-28 · Centre, ALApr 27, 1969 · N9829W · Substantial damage NTSB MIA69D0455Accident · No injuriesClosedTermite BR-44 · Gadsden, ALApr 26, 1969 · N3101 · Substantial damage NTSB MIA69D0487Accident · No injuriesClosedPiper PA-28 · Laceys Spring, ALApr 25, 1969 · N7931W · Substantial damage NTSB MIA69F0442Accident · No injuriesClosedCessna 172 · Opelika, ALApr 21, 1969 · N1429F · Substantial damage NTSB MIA70F0019Accident · No injuriesClosedBell 47G-4 · Gunterville, ALApr 15, 1969 · N1415W · Destroyed NTSB MIA69D0437Accident · No injuriesClosedCessna 150 · Tuscaloosa, ALApr 11, 1969 · N4070J · Substantial damage NTSB MIA69D0424Accident · No injuriesClosedPiper PA-28 · Auburn, ALApr 11, 1969 · N5951W · Substantial damage NTSB MIA69F0430Accident · No injuriesClosedGlobe Swift GC-1B · Weaver, ALApr 8, 1969 · N80922 · Substantial damage NTSB MIA69D0493Accident · No injuriesClosedCessna 150 · Laceys Spring, ALApr 5, 1969 · N2262J · Substantial damage NTSB MIA69F0425Accident · Minor injuriesClosedPiper J-3 · Laceys Spring, ALMar 20, 1969 · N58378 · Substantial damage NTSB MIA69D0407Accident · No injuriesClosedBeech C35 · Hartselle, ALMar 20, 1969 · N5918C · Substantial damage NTSB MIA69D0432Accident · No injuriesClosedSmith JDL-1 · Ozark, ALMar 17, 1969 · N1652 · Substantial damage NTSB MIA69S0002Accident · 1 fatalClosedCessna 182 · Gordo, ALMar 16, 1969 · N6322A · No damage NTSB MIA69D0467Accident · No injuriesClosedAeronca 7AC · Lanett, ALMar 2, 1969 · N82208 · Substantial damage NTSB MIA69F0416Accident · 1 fatalClosedStinson 108-2 · Russellville, ALFeb 21, 1969 · N97478 · Destroyed NTSB MIA69D0371Accident · No injuriesClosedLuscombe 8A · Bessemer, ALFeb 19, 1969 · N1145B · Substantial damage NTSB MIA69D0364Accident · No injuriesClosedCessna 172 · Auburn, ALFeb 5, 1969 · N1143F · Substantial damage NTSB MIA69D0360Accident · No injuriesClosedCessna 182 · Meridianville, ALFeb 2, 1969 · N6275A · Substantial damage NTSB MIA69F0327Accident · No injuriesClosedCessna 172 · Enterprise, ALJan 26, 1969 · N8822B · Substantial damage NTSB MIA69D0329Accident · No injuriesClosedCessna 182 · Ragland, ALJan 7, 1969 · N8933X · Substantial damage NTSB MIA69F0320Accident · No injuriesClosedPiper PA-28 · Enterprise, ALJan 4, 1969 · N4536J · Substantial damage NTSB MIA69D0335Accident · No injuriesClosedCessna 177 · Lacey Sprgs, ALDec 20, 1968 · N2385Y · Substantial damage NTSB MIA69F0316Accident · Serious injuriesClosedCessna 172 · Heflin, ALDec 19, 1968 · N46271 · Substantial damage NTSB MIA69F0333Accident · No injuriesClosedPiper PA-22 · Goshen, ALDec 7, 1968 · N2376P · Substantial damage NTSB MIA69D0243Accident · No injuriesClosedCessna 120 · Geneva, ALNov 24, 1968 · N90177 · Substantial damage NTSB MIA69I0259Incident · No injuriesClosedPiper J-3 · Ozark, ALNov 23, 1968 · N98576 · No damage NTSB MIA69D0247Accident · No injuriesClosedCessna 182L · Weaver, ALNov 20, 1968 · N3447R · Substantial damage NTSB MIA69D0248Accident · No injuriesClosedPiper PA-32 · Gadsden, ALNov 4, 1968 · N3441W · Substantial damage NTSB MIA69F0205Accident · No injuriesClosedMooney M20 · Andalusia, ALOct 21, 1968 · N9540M · Substantial damage NTSB MIA69F0197Accident · Serious injuriesClosedPiper J3C-65 · Headland, ALOct 20, 1968 · N92043 · Substantial damage NTSB MIA69F0204Accident · No injuriesClosedCessna 210 · Montgomery, ALSep 28, 1968 · N9666T · Substantial damage NTSB MIA69F0193Accident · No injuriesClosedCessna 172 · Clopton, ALSep 27, 1968 · N8822B · Substantial damage NTSB MIA69F0188Accident · No injuriesClosedBeech 35-C33 · Birmingham, ALSep 26, 1968 · N5808K · Substantial damage NTSB MIA69D0179Accident · No injuriesClosedCessna 150H · Elmore, ALSep 26, 1968 · N7088S · Substantial damage NTSB MIA69F0200Accident · No injuriesClosedMooney M20C · Decatur, ALSep 23, 1968 · N6620U · Substantial damage NTSB MIA69A0016Accident · 2 fatalClosedPiper PA-28 · Eufaula, ALSep 22, 1968 · N6544W · Destroyed NTSB MIA69F0165Accident · No injuriesClosedCessna 150 · Pell City, ALSep 9, 1968 · N22614 · Substantial damage NTSB MIA69D0199Accident · No injuriesClosedMooney M20A · Headland, ALSep 8, 1968 · N82EA · Substantial damage NTSB MIA69D0163Accident · No injuriesClosedCessna 150 · Skipperville, ALSep 7, 1968 · N8207S · Substantial damage NTSB MIA69F0174Accident · Serious injuriesClosedPiper PA-23 · Montgomery, ALAug 28, 1968 · N3376P · Destroyed NTSB MIA69D0130Accident · No injuriesClosedCessna 150G · Montgomery, ALAug 24, 1968 · N2760S · Substantial damage NTSB MIA69F0137Accident · Minor injuriesClosedPiper PA-25 · River Falls, ALAug 23, 1968 · N4697Y · Substantial damage NTSB MIA69D0151Accident · Minor injuriesClosedPiper PA-18 · Decatur, ALAug 22, 1968 · N7868D · Substantial damage NTSB MIA69D0129Accident · No injuriesClosedBoeing A75 · Monroeville, ALAug 21, 1968 · N55175 · Substantial damage NTSB MIA69D0128Accident · No injuriesClosedPiper PA-18 · Cottonwood, ALAug 19, 1968 · N9490D · Substantial damage NTSB MIA69F0098Accident · No injuriesClosedPiper PA-24 · Huntsville, ALAug 4, 1968 · N8906P · Substantial damage NTSB MIA69F0053Accident · No injuriesClosedPiper PA-25 · Harpersville, ALAug 3, 1968 · N6465Z · Substantial damage NTSB MIA69D0082Accident · No injuriesClosedCessna 182L · Muscle Shoals, ALJul 31, 1968 · N3456R · Substantial damage