Skip to content

NTSB investigations, 1973, CT

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 per year

19622026

NTSB investigations, 1973, CT per year, 1962–2026: 1,081 cases
1962	1
1964	32
1965	45
1966	50
1967	48
1968	34
1969	31
1970	34
1971	40
1972	31
1973	34
1974	24
1975	22
1976	18
1977	27
1978	26
1979	26
1980	21
1981	14
1982	22
1983	21
1984	33
1985	17
1986	23
1987	24
1988	17
1989	18
1990	17
1991	15
1992	21
1993	15
1994	13
1995	10
1996	14
1997	8
1998	16
1999	10
2000	9
2001	15
2002	12
2003	8
2004	13
2005	9
2006	7
2007	7
2008	9
2009	2
2010	4
2011	11
2012	6
2013	7
2014	5
2015	9
2016	8
2017	13
2018	8
2019	8
2020	5
2021	5
2022	5
2023	6
2024	6
2025	9
2026	3

Where

Latest cases

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 AND c."eventStateOrRegion" = 'CT' 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 year(c.\"eventDate\") = 1973
    AND c.\"eventStateOrRegion\" = 'CT' 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 year(c."eventDate") = 1973
  AND c."eventStateOrRegion" = 'CT' 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 NYC74IN054Incident · No injuriesClosedBeech E18S · Windsor Lock, CTDec 19, 1973 · N111EH · Minor damage NTSB NYC74AN052Accident · 2 fatalClosedBeech G35 · Chaplin, CTDec 8, 1973 · N118B · Destroyed NTSB NYC74FNE13Accident · No injuriesClosedCessna 150L · Chester, CTDec 1, 1973 · N18130 · Substantial damage NTSB NYC74FNE12Accident · Minor injuriesClosedCessna 150K · Hartford, CTNov 18, 1973 · N6209G · Substantial damage NTSB NYC74FNE11Accident · No injuriesClosedCessna 150L · Oxford, CTNov 10, 1973 · N6861G · Substantial damage NTSB NYC74FNE10Accident · No injuriesClosedCessna 140 · Simsbury, CTNov 2, 1973 · N4220N · Substantial damage NTSB NYC74AN039Accident · No injuriesClosedPiper PA-28 · Hartford, CTOct 31, 1973 · N2133T · 2 aircraft · Minor damage NTSB NYC74FNE09Accident · No injuriesClosedBeech E55 · New Haven, CTOct 21, 1973 · N4EN · Substantial damage NTSB NYC74FNE08Accident · No injuriesClosedAero Comdr 112 · Hartford, CTOct 10, 1973 · N88MS · Substantial damage NTSB NYC74FNE05Accident · No injuriesClosedTemco GC-1B · Hartford, CTSep 15, 1973 · N2339B · Substantial damage NTSB NYC74IN023Incident · No injuriesClosedBeech 95-C55 · Windsor Lock, CTSep 14, 1973 · N5943S · Minor damage NTSB NYC74AN021Accident · 2 fatalClosedAeronca S11AC · New Milford, CTSep 8, 1973 · N3910E · Destroyed NTSB NYC74FNE01Accident · No injuriesClosedBoeing PT-13D · Ellington, CTJul 24, 1973 · N1300V · Substantial damage NTSB NYC73AN002Accident · 3 fatalClosedPiper PA-28 · Tolland, CTJul 4, 1973 · N4470T · Destroyed NTSB NYC73FNE37Accident · No injuriesClosedCessna 150 · Hartford, CTJun 28, 1973 · N6613G · Substantial damage NTSB NYC73AN156Accident · 2 fatalClosedPiper PA-28 · Killingworth, CTJun 25, 1973 · N6427W · Destroyed NTSB NYC73FNE34Accident · No injuriesClosedPiper PA-28 · Danbury, CTJun 10, 1973 · N9591W · Destroyed NTSB NYC73AN150Accident · 1 fatalClosedPiper PA-28 · Haddam, CTJun 9, 1973 · N5456W · Destroyed NTSB NYC73FNE32Accident · Minor injuriesClosedErco 415-D · Waterford, CTApr 30, 1973 · N99416 · Substantial damage NTSB NYC73AN137Accident · 1 fatalClosedMooney M20C · Ledyard, CTApr 27, 1973 · N9278V · Destroyed NTSB NYC73FNE31Accident · No injuriesClosedPiper PA-28R · Waterford, CTApr 22, 1973 · N2866R · Substantial damage NTSB NYC73FNE29Accident · No injuriesClosedScorpion II · Meriden, CTApr 17, 1973 · N8851 · Substantial damage NTSB NYC73DNE28Accident · No injuriesClosedDavis D-1K · Chester, CTApr 14, 1973 · N158Y · Substantial damage NTSB NYC73AN129Accident · 3 fatalClosedPiper PA-28 · Bantam, CTApr 3, 1973 · N2660T · Destroyed NTSB NYC73FNE27Accident · No injuriesClosedPiper PA-28 · Danielson, CTMar 28, 1973 · N95011 · Substantial damage NTSB NYC73FNE26Accident · No injuriesClosedStinson 108-1 · Somers, CTMar 28, 1973 · N8485K · Substantial damage NTSB NYC73FNE24Accident · Serious injuriesClosedCessna TP206 · Greenwich, CTMar 13, 1973 · N100QT · Substantial damage NTSB NYC73FNE22Accident · No injuriesClosedPiper PA-34 · Danbury, CTMar 10, 1973 · N4886T · Substantial damage NTSB NYC73FNE23Accident · Minor injuriesClosedCessna 172L · Plainville, CTMar 8, 1973 · N7843G · Substantial damage NTSB NYC73FNE19Accident · Minor injuriesClosedPiper PA-28 · Ellington, CTJan 21, 1973 · N95321 · Destroyed NTSB NYC73DNE20Accident · No injuriesClosedPiper PA-22 · Windsor Lock, CTJan 20, 1973 · N5513Z · Substantial damage NTSB NYC73FNE17Accident · No injuriesClosedPiper J5 · Voluntown, CTJan 9, 1973 · N30886 · Substantial damage NTSB NYC73FNE16Accident · No injuriesClosedPiper PA-28 · Ellington, CTJan 9, 1973 · N6497J · Substantial damage NTSB NYC73ANE15Accident · Serious injuriesClosedCessna 182L · Easton, CTJan 6, 1973 · N3356R · Destroyed