Skip to content

NTSB investigations, 1972

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 year(c."eventDate") = 1972 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 year(c.\"eventDate\") = 1972
  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 year(c."eventDate") = 1972
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 MKC73DCJ25Accident · No injuriesClosedPiper PA-34 · Grand Island, NENov 26, 1972 · N1063U · Substantial damage NTSB MIA73DLD37Accident · No injuriesClosedLake LA-4 · Ft Pierce, FLNov 26, 1972 · N5025L · Substantial damage NTSB MIA73DKT67Accident · No injuriesClosedBell 47H-1 · Naples, FLNov 26, 1972 · N2818B · Substantial damage NTSB FTW73FQG24Accident · No injuriesClosedAero Comdr 500-B · Sonora, TXNov 26, 1972 · N620TW · Substantial damage NTSB DEN73DQD11Accident · No injuriesClosedBeech A36 · Pinon, NMNov 26, 1972 · N4467A · Substantial damage NTSB CHI73FLQ18Accident · Minor injuriesClosedPiper PA-23 · Leitchfield, KYNov 26, 1972 · N2273P · Substantial damage NTSB CHI73FEV16Accident · No injuriesClosedPiper PA-24 · Burnt Prairie, ILNov 26, 1972 · N5186P · Substantial damage NTSB ANC73DAG66Accident · No injuriesClosedPiper PA-18 · Glenallen, AKNov 26, 1972 · N5993Z · Substantial damage NTSB ANC73DAA17Accident · No injuriesClosedChampion 7EAC · Fairbanks, AKNov 26, 1972 · N9624S · Substantial damage NTSB OAK73FJA08Accident · 1 fatalClosedPiper J5C · Kaanapali, HINov 25, 1972 · N62032 · Destroyed NTSB OAK73DJA07Accident · No injuriesClosedCessna 305C · Wheelr Afb, HINov 25, 1972 · N5639V · Substantial damage NTSB OAK73AP012Accident · 2 fatalClosedCessna A150L · Yorkville, CANov 25, 1972 · N5949J · Destroyed NTSB NYC73IN073Incident · Minor injuriesClosedBeech A65-88 · Rocky Mount, NCNov 25, 1972 · N887J · Minor damage NTSB NYC73FIJ11Accident · No injuriesClosedCessna 206D · Dublin, VANov 25, 1972 · N71964 · Substantial damage NTSB NYC73FID11Accident · No injuriesClosedPiper PA-24 · Hopewell, VANov 25, 1972 · N6946P · Substantial damage NTSB NYC73DNC42Accident · No injuriesClosedLuscombe 8F · Turner, MENov 25, 1972 · N1553B · Substantial damage NTSB NYC73DNC40Accident · No injuriesClosedPiper PA-32 · Ludlow, VTNov 25, 1972 · N4026R · Substantial damage NTSB NYC73DHD20Accident · Minor injuriesClosedPiper PA-23 · Chester, PANov 25, 1972 · N6185Y · Substantial damage NTSB MIA73FKT29Accident · No injuriesClosedCessna 310C · Naples, FLNov 25, 1972 · N6676B · Substantial damage NTSB MIA73FKT28Accident · Serious injuriesClosedCessna A150K · Pompano Beach, FLNov 25, 1972 · N8434M · Substantial damage NTSB MIA73DKW11Accident · Serious injuriesClosedCessna 177 · Flagpond, TNNov 25, 1972 · N2360Y · Substantial damage NTSB MIA73AM057Accident · 4 fatalClosedPiper PA-23 · Jacksonville, FLNov 25, 1972 · N5908Y · Destroyed NTSB LAX73DUM11Accident · No injuriesClosedCessna 180 · Calexico, CANov 25, 1972 · N1626C · Substantial damage NTSB LAX73DUM10Accident · No injuriesClosedCessna 140 · Borrego Sgs, CANov 25, 1972 · N3113N · Substantial damage NTSB LAX73DUJ38Accident · No injuriesClosedPiper PA-28 · Yuma, AZNov 25, 1972 · N5414S · Substantial damage NTSB DEN73AD025Accident · 1 fatalClosedPiper PA-23 · Nederland, CONov 25, 1972 · N6767Y · Destroyed NTSB ANC73DAG65Accident · No injuriesClosedPiper PA-18 · Glenallen, AKNov 25, 1972 · N7873D · Substantial damage NTSB NYC73DNC39Accident · No injuriesClosedBell 206A · Mount Snow, VTNov 24, 1972 · N3527T · Substantial damage NTSB NYC73DHJ15Accident · No injuriesClosedCessna 182L · Jamaica, NYNov 24, 1972 · N141HB · Substantial damage NTSB MKC73DCJ24Accident · No injuriesClosedPiper PA-28 · Ogallala, NENov 24, 1972 · N2683T · Substantial damage NTSB LAX73FUQ17Accident · Minor injuriesClosedPiper PA-28 · Goleta, CANov 24, 1972 · N403FL · Destroyed NTSB LAX73FUG26Accident · No injuriesClosedCessna 206 · El Monte, CANov 24, 1972 · N8756Z · Substantial damage NTSB CHI73ICO61Incident · No injuriesClosedConvair 580 · Chicago, ILNov 24, 1972 · N4810C · 2 aircraft · Minor damage NTSB SEA73FYE20Accident · No injuriesClosedPiper PA-28 · Monroe, WANov 23, 1972 · N9694W · Substantial damage NTSB NYC73AN071Accident · 2 fatalClosedPiper PA-28R · Weston, WVNov 23, 1972 · N2335T · Destroyed NTSB MIA73FKT27Accident · No injuriesClosedPiper PA-24 · Opa Locka, FLNov 23, 1972 · N5005P · Substantial damage NTSB MIA73DKG57Accident · No injuriesClosedEaa Biplane P · Macon, GANov 23, 1972 · N1419 · Destroyed NTSB DEN73ADO24Accident · 1 fatalClosedLuscombe 8A · Cody, WYNov 23, 1972 · N28409 · Destroyed NTSB CHI73FEC17Accident · Minor injuriesClosedAmer Avco AA1A · Detroit, MINov 23, 1972 · N9204L · Substantial damage NTSB CHI73DEE33Accident · No injuriesClosedPiper PA-22 · Lockport, ILNov 23, 1972 · N1170C · Substantial damage NTSB NYC73FGM13Accident · Serious injuriesClosedPiper PA-32 · Roaring Spring, PANov 22, 1972 · N8672N · Substantial damage NTSB NYC73DKM18Accident · No injuriesClosedCessna 206 · Lenoir, NCNov 22, 1972 · N5012U · Substantial damage NTSB MKC73DCD44Accident · No injuriesClosedCessna 172 · Fontanelle, IANov 22, 1972 · N7814 · Substantial damage NTSB MKC73DCD43Accident · No injuriesClosedCessna 150L · Ames, IANov 22, 1972 · N1339Q · Substantial damage NTSB MIA73IM055Incident · No injuriesClosedBoeing 747 · Miami, FLNov 22, 1972 · N754PA · Minor damage NTSB MIA73AM056Accident · 1 fatalClosedBell 47G-2 · Miami, FLNov 22, 1972 · N5188B · Destroyed NTSB LAX73OL006Accident · 3 fatalClosedPiper PA-24 · Topia, MexicoNov 22, 1972 · N8581P · Destroyed NTSB LAX73FUM12Accident · Minor injuriesClosedMooney M20E · Calexico, CANov 22, 1972 · N3363X · Substantial damage NTSB FTW73FRD11Accident · No injuriesClosedPiper PA-28 · New Orleans, LANov 22, 1972 · N486FL · Substantial damage NTSB FTW73DRJ24Accident · Minor injuriesClosedAeronca 7DC · Lk Providence, LANov 22, 1972 · N81475 · Substantial damage