Skip to content

NTSB investigations, 1973

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") = 1973 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\") = 1973
  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") = 1973
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 NYC74AN050Accident · 1 fatalClosedPiper PA-23 · Hanover, NHNov 28, 1973 · N13978 · Destroyed NTSB MKC74DCG15Accident · No injuriesClosedAeronca 11AC · Ava, MONov 27, 1973 · N85875 · Substantial damage NTSB MKC74AK028Accident · 1 fatalClosedBeech E18S · Muscatine, IANov 27, 1973 · N262AA · Destroyed NTSB MIA74OKT42Accident · No injuriesClosedPiper PA-23 · G Bahama I, Burkina FasoNov 27, 1973 · N5ML · Substantial damage NTSB MIA74DLD45Accident · No injuriesClosedMooney M20F · Ft Pierce, FLNov 27, 1973 · N6424Q · Substantial damage NTSB LAX74DVA35Accident · Minor injuriesClosedCessna 182 · Kernville, CANov 27, 1973 · N3485F · Substantial damage NTSB LAX74AL042Accident · 3 fatalClosedCessna 310C · San Diego, CANov 27, 1973 · N1732H · 2 aircraft · Destroyed NTSB FTW74FPJ13Accident · Minor injuriesClosedAeronca 7AC · Wynnewood, OKNov 27, 1973 · N1020E · Substantial damage NTSB FTW74AF039Accident · 2 fatalClosedCessna 337 · Marathon, TXNov 27, 1973 · N86198 · Destroyed NTSB DCA74AZ012Accident · Serious injuriesClosedDouglas DC-9 · North Canton, OHNov 27, 1973 · N8967E · Substantial damage NTSB DCA74AZ011Accident · Serious injuriesClosedDouglas DC-9 · Chattanooga, TNNov 27, 1973 · N3323L · Destroyed NTSB NYC74FHA17Accident · Minor injuriesClosedCessna 172 · Moscow, PANov 26, 1973 · N92136 · Destroyed NTSB NYC74AN049Accident · 1 fatalClosedPiper PA-28 · Lake Scranton, PANov 26, 1973 · N4978L · Destroyed NTSB MKC74IK026Incident · No injuriesClosedPiper PA-32 · Readsville, MONov 26, 1973 · N3977W · Minor damage NTSB MKC74AK027Accident · Serious injuriesClosedBeech 35 · Charles City, IANov 26, 1973 · N6094E · Destroyed NTSB IAD74AI030Accident · 5 fatalClosedMooney M20C · Lenoir, NCNov 26, 1973 · N5515Q · Destroyed NTSB FTW74DRG38Accident · No injuriesClosedCessna 182 · San Luis Ptsi, MexicoNov 26, 1973 · N3352Y · Substantial damage NTSB DEN74DTC21Accident · No injuriesClosedMaule M4220C · Gillette, WYNov 26, 1973 · N2080U · Substantial damage NTSB CHI74AC044Accident · 3 fatalClosedPiper PA-23 · Sandusky, OHNov 26, 1973 · N3364P · Destroyed NTSB UNK74X0100Accident · 1 fatalClosedBeech D55 · Honiara, BPNov 25, 1973 · N7499N · Destroyed NTSB OAK74DJY07Accident · Minor injuriesClosedPilatus PC6CH2 · Ling Tieng, LaosNov 25, 1973 · N5304F · Destroyed NTSB NYC74AN048Accident · 3 fatalClosedPiper PA-28 · Donnally Mills, PANov 25, 1973 · N8056W · Destroyed NTSB MIA74FLD47Accident · 1 fatalClosedJodel F-12 · Ormond Beach, FLNov 25, 1973 · N9DH · Destroyed NTSB MIA74FLA25Accident · No injuriesClosedMaule M4220C · Ft George, FLNov 25, 1973 · N40650 · Substantial damage NTSB MIA74DLA24Accident · No injuriesClosedCessna 210 · Tallahassee, FLNov 25, 1973 · N6638X · Substantial damage NTSB LAX74FUG30Accident · No injuriesClosedSchmidt JR II · Chino, CANov 25, 1973 · N17RS · Destroyed NTSB LAX74DUG26Accident · No injuriesClosedCessna TU206C · Perris, CANov 25, 1973 · N3958G · 2 aircraft · Substantial damage NTSB IAD74AI029Accident · 1 fatalClosedCessna U206C · Hayesville, NCNov 25, 1973 · N29241 · Destroyed NTSB IAD74AI028Accident · 2 fatalClosedPiper PA-23 · Heaton, NCNov 25, 1973 · N1391P · Destroyed NTSB FTW74AF038Accident · 2 fatalClosedPiper PA-23 · Navasota, TXNov 25, 1973 · N2067P · Destroyed NTSB ANC74AA048Accident · 1 fatalClosedAeronca 15AC · Missing AircraftNov 25, 1973 · N1373H · Destroyed NTSB MIA74DKG44Accident · No injuriesClosedCessna 172 · Covington, GANov 24, 1973 · N6910X · Substantial damage NTSB MIA74AM048Accident · 1 fatalClosedCessna 150H · Ashland, ALNov 24, 1973 · N22591 · Destroyed NTSB LAX74DUJ36Accident · No injuriesClosedPiper PA-28R · Gila Bend, AZNov 24, 1973 · N4995S · Substantial damage NTSB LAX74AL041Accident · 3 fatalClosedMooney M-20 · Fillmore, CANov 24, 1973 · N5259B · Destroyed NTSB FTW74DQG34Accident · No injuriesClosedCessna 177RG · Lehman, TXNov 24, 1973 · N8015G · Substantial damage NTSB OAK74DXQ15Accident · No injuriesClosedCessna 120 · Emigrnt Gap, CANov 23, 1973 · N77212 · Substantial damage NTSB NYC74FHA18Accident · No injuriesClosedMooney M20A · Lake Sheridan, PANov 23, 1973 · N8331E · Substantial damage NTSB LAX74FUG27Accident · No injuriesClosedCessna 150 · Rialto, CANov 23, 1973 · N2978J · Substantial damage NTSB LAX74DUG25Accident · No injuriesClosedWhigham GW-4 · Elsinore, CANov 23, 1973 · N3705 · Substantial damage NTSB IAD74FIG14Accident · 1 fatalClosedVolksplane VP-1 · Uniontown, MDNov 23, 1973 · N47244 · Substantial damage NTSB FTW74DRJ19Accident · Minor injuriesClosedCessna 150 · Minden, LANov 23, 1973 · N11229 · Substantial damage NTSB FTW74DPD30Accident · Minor injuriesClosedBensen B8M · Olney, TXNov 23, 1973 · N6237 · Destroyed NTSB FTW74AF037Accident · 1 fatalClosedCessna 180B · Enid, OKNov 23, 1973 · N5083E · Destroyed NTSB CHI74DEA21Accident · No injuriesClosedPiper PA-28R · Madison, INNov 23, 1973 · N9482N · Substantial damage NTSB CHI74AC043Accident · 4 fatalClosedPiper PA-28 · Delavan, WINov 23, 1973 · N16327 · Destroyed NTSB ANC74AA047Accident · 3 fatalClosedCessna 180C · Anchorage, AKNov 23, 1973 · N4669S · Destroyed NTSB ANC74AA046Accident · 1 fatalClosedAero Comdr 560A · Galena, AKNov 23, 1973 · N12317 · Destroyed NTSB NYC74DNA27Accident · No injuriesClosedBeech 35C33A · Hyannis, MANov 22, 1973 · N7978M · Substantial damage NTSB MKC74FCG14Accident · Minor injuriesClosedLuscombe T8-F · Lenexa, KSNov 22, 1973 · N1824B · Substantial damage