Skip to content

NTSB investigations, 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, 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" = '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 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 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 NYC76FNE21Accident · Minor injuriesClosedSchweizer SGS135 · Plymouth, CTMay 28, 1976 · N34189 · Substantial damage NTSB NYC77FNE16Accident · No injuriesClosedPiper PA-28 · Ellington, CTApr 13, 1976 · N6214J · Substantial damage NTSB NYC76FNE17Accident · Serious injuriesClosedPiper PA-28 · Waterford, CTMar 10, 1976 · N8752N · Substantial damage NTSB NYC76FNE16Accident · Minor injuriesClosedCessna 172K · Windsor Locks, CTFeb 28, 1976 · N84760 · Substantial damage NTSB NYC76AN073Accident · 2 fatalClosedCessna 150 · Bridgeport, CTFeb 4, 1976 · N248Q · Destroyed NTSB NYC76FNE10Accident · Minor injuriesClosedCessna 172F · Stratford, CTNov 28, 1975 · N8456U · Substantial damage NTSB NYC76FNE09Accident · Minor injuriesClosedCessna 195B · Madison, CTOct 2, 1975 · N4321N · Substantial damage NTSB NYC76FNE06Accident · No injuriesClosedSchweizer SGS233 · Plymouth, CTSep 28, 1975 · N33988 · Substantial damage NTSB NYC76AN031Accident · No injuriesClosedRaven S55A · Greenwich, CTSep 7, 1975 · N51508 · No damage NTSB NYC76AN023Accident · 1 fatalClosedCessna 172M · Stamford, CTAug 17, 1975 · N22234 · Destroyed NTSB NYC76AN013Accident · 1 fatalClosedCessna 150 · Broad Brook, CTJul 27, 1975 · N1286Q · Substantial damage NTSB NYC76FNE01Accident · Minor injuriesClosedPiper J-3 · Canaan, CTJul 12, 1975 · N24881 · Substantial damage NTSB NYC76AN002Accident · No injuriesClosedCessna 150 · Marlborough, CTJul 5, 1975 · N3874V · 2 aircraft · Substantial damage NTSB NYC75FNE02Accident · No injuriesClosedPiper PA-28 · Ansonia, CTJul 2, 1975 · N98267 · Substantial damage NTSB NYC75FNE40Accident · No injuriesClosedChampion 7GCBA · Waterbury, CTJun 23, 1975 · N1880G · Substantial damage NTSB NYC75FNE38Accident · Minor injuriesClosedBeech B19 · Barkhamsted, CTMay 29, 1975 · N73AK · Destroyed NTSB NYC75AN112Accident · 2 fatalClosedBeech A45 · Southport, CTMay 29, 1975 · N1061X · Destroyed NTSB NYC75FNE35Accident · No injuriesClosedPiper PA-28 · Danielson, CTMay 13, 1975 · N95011 · Substantial damage NTSB NYC75FNE33Accident · Minor injuriesClosedBellanca 8KCAB · Simsbury, CTApr 26, 1975 · N9178L · Substantial damage NTSB NYC75FNE32Accident · No injuriesClosedCessna A150L · Simsbury, CTApr 5, 1975 · N6503F · Substantial damage NTSB NYC75AN095Accident · 2 fatalClosedBell 206B · Shelton, CTMar 25, 1975 · N83176 · Destroyed NTSB NYC75FNE29Accident · No injuriesClosedMesserschmt ME109 · Oxford, CTFeb 28, 1975 · N90605 · Substantial damage NTSB NYC75FNE27Accident · No injuriesClosedCessna 172 · Plymouth, CTFeb 15, 1975 · N7205E · Substantial damage NTSB NYC75AN082Accident · 1 fatalClosedBell 206A · Milford, CTFeb 1, 1975 · N4726R · Destroyed NTSB NYC75FNE26Accident · Serious injuriesClosedBeech A23 · Simsbury, CTJan 22, 1975 · N6949Q · Substantial damage NTSB NYC75AN080Accident · 1 fatalClosedCessna 210 · Middlebury, CTJan 11, 1975 · N54CB · Destroyed NTSB NYC75AN079Accident · 1 fatalClosedPiper PA-23 · Stratford, CTJan 10, 1975 · N4322Y · Substantial damage NTSB NYC75FNE21Accident · No injuriesClosedCessna 172I · Oxford, CTDec 15, 1974 · N46096 · Substantial damage NTSB NYC75FNE22Accident · Serious injuriesClosedCessna 180 · New Milford, CTDec 10, 1974 · N4966A · Substantial damage NTSB NYC75FNE20Accident · Minor injuriesClosedCessna 172 · Greenwich, CTNov 24, 1974 · N7425T · Substantial damage NTSB NYC75FNE18Accident · No injuriesClosedCessna 172 · Danielson, CTNov 9, 1974 · N46656 · Destroyed NTSB NYC75AN053Accident · 1 fatalClosedPiper PA-28 · East Hampton, CTOct 25, 1974 · N1698T · Destroyed NTSB NYC75FNE17Accident · 1 fatalClosedSchriever Trpedo · Chesire, CTOct 19, 1974 · N73697 · Destroyed NTSB NYC75AN048Accident · No injuriesClosedCessna 500 · New Haven, CTOct 16, 1974 · N85AT · Substantial damage NTSB NYC75FNE14Accident · No injuriesClosedCessna 195B · Danbury, CTOct 6, 1974 · N2154C · 2 aircraft · Substantial damage NTSB NYC75FNE18Accident · No injuriesClosedCessna 177 · Bridgeport, CTOct 1, 1974 · N30043 · Substantial damage NTSB NYC75FNE11Accident · Minor injuriesClosedErco 415-C · Ansonia, CTSep 22, 1974 · N320D · Substantial damage NTSB NYC75FNE10Accident · No injuriesClosedLake LA-4 · East Haddam, CTSep 8, 1974 · N39797 · Substantial damage NTSB NYC75AN031Accident · 1 fatalClosedCessna 150L · Southbury, CTSep 5, 1974 · N6861G · Destroyed NTSB NYC75AN030Accident · 3 fatalClosedAmer Avco AA-5 · Roxbury, CTSep 1, 1974 · N7114L · Destroyed NTSB NYC75AN024Accident · 1 fatalClosedBeech F35 · Madison, CTAug 26, 1974 · N5065B · Destroyed NTSB NYC75FNE03Accident · No injuriesClosedBeech 65-80 · Windsr Locks, CTAug 3, 1974 · N1725G · Substantial damage NTSB NYC74FNE01Accident · No injuriesClosedPiper PA-28 · Ellington, CTJul 6, 1974 · N5820U · Substantial damage NTSB NYC74FNE29Accident · Serious injuriesClosedEea Biplane · Danielson, CTJun 22, 1974 · N15PH · Destroyed NTSB NYC75FNE27Accident · Serious injuriesClosedCessna 210 · Meriden, CTJun 5, 1974 · N1175Q · Substantial damage NTSB NYC74FNE26Accident · No injuriesClosedPiper PA-22 · Plymouth, CTMay 27, 1974 · N2934Z · Substantial damage NTSB NYC74FNE24Accident · Minor injuriesClosedCessna 150 · Sherman, CTMay 17, 1974 · N8684J · Substantial damage NTSB NYC74FNE21Accident · Serious injuriesClosedCessna 150L · Ashford, CTApr 26, 1974 · N5358Q · Destroyed NTSB NYC74FNE20Accident · No injuriesClosedEnstrom F-28A · East Putman, CTApr 21, 1974 · N4895 · Destroyed NTSB NYC74FNE19Accident · No injuriesClosedAero Comdr 100 · W Goshen, CTApr 21, 1974 · N4138X · Substantial damage