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 NYC66F0493Accident · No injuriesClosedBeechcraft C45H · Windsor Locks, CTFeb 9, 1966 · N168L · Substantial damage NTSB NYC66D0441Accident · No injuriesClosedPiper PA-22 · Hartford, CTJan 22, 1966 · N8546C · Substantial damage NTSB NYC66D0445Accident · No injuriesClosedStinson 108-3 · Hartford, CTJan 11, 1966 · N4213C · Substantial damage NTSB NYC66D0399Accident · No injuriesClosedPiper PA-28 · Hartford, CTDec 23, 1965 · N7649W · Substantial damage NTSB NYC66D0396Accident · No injuriesClosedPiper PA-22 · Danbury, CTDec 20, 1965 · N4967Z · Substantial damage NTSB NYC66F0375Accident · No injuriesClosedCessna T-50 · Jewett City, CTNov 25, 1965 · N58309 · Substantial damage NTSB NYC66F0368Accident · No injuriesClosedPiper PA-28 · Deep River, CTNov 21, 1965 · N5642W · Substantial damage NTSB NYC66F0370Accident · Serious injuriesClosedPiper PA-22 · Greenwich, CTNov 6, 1965 · N5752Z · Destroyed NTSB NYC66F0284Accident · No injuriesClosedCessna 150 · Danbury, CTOct 26, 1965 · N6293T · Substantial damage NTSB NYC66D0292Accident · No injuriesClosedCessna 150 · Hartford, CTOct 24, 1965 · N3545J · Substantial damage NTSB NYC66D0301Accident · No injuriesClosedMooney M20C · Danbury, CTOct 12, 1965 · N5834Q · Substantial damage NTSB NYC66D0294Accident · No injuriesClosedPiper PA-28 · Hartford, CTOct 10, 1965 · N6937W · Substantial damage NTSB NYC66A0047Accident · 4 fatalClosedStinson SR-7 · New Haven, CTOct 10, 1965 · N16113 · Destroyed NTSB NYC66F0244Accident · No injuriesClosedCessna 172 · Harwinton, CTOct 3, 1965 · N7459T · Substantial damage NTSB NYC66A0010Accident · 3 fatalClosedPiper PA-22 · E.Hartford, CTSep 26, 1965 · N8120C · Destroyed NTSB NYC66F0234Accident · No injuriesClosedBeechcraft C-45H · Groton, CTSep 13, 1965 · N135L · Substantial damage NTSB NYC66D0231Accident · No injuriesClosedCessna 172 · Litchfield, CTSep 9, 1965 · N8790B · Substantial damage NTSB NYC66F0201Accident · Minor injuriesClosedBeechcraft 35 · Monroe, CTAug 25, 1965 · N3249V · Substantial damage NTSB NYC66D0177Accident · No injuriesClosedBellanca 14-19 · So Canaan, CTAug 18, 1965 · N9809B · Substantial damage NTSB NYC66F0069Accident · No injuriesClosedCessna 172F · E Killingly, CTJul 13, 1965 · N5551R · Substantial damage NTSB NYC66F0108Accident · Serious injuriesClosedAero Cmdr 560 · Danbury, CTJul 12, 1965 · N2654B · Substantial damage NTSB NYC66F0082Accident · No injuriesClosedBeechcraft 35 · Hardwinton, CTJul 9, 1965 · N3329V · Substantial damage NTSB NYC66F0056Accident · Minor injuriesClosedMiniplane DSA-1 · New Haven, CTJul 3, 1965 · N9155R · Substantial damage NTSB NYC66F0032Accident · Serious injuriesClosedPiper J3 · East Windsor, CTJul 2, 1965 · N92699 · Substantial damage NTSB NYC66D0073Accident · No injuriesClosedCessna 170B · Hartford, CTJun 30, 1965 · N113E · Substantial damage NTSB NYC66F0092Accident · Serious injuriesClosedPiper PA23 · New Haven, CTJun 29, 1965 · N5253Y · Destroyed NTSB NYC65A0152Accident · 1 fatalClosedCessna 170 · E.Haddam, CTJun 20, 1965 · N3506D · Substantial damage NTSB NYC66F0024Accident · No injuriesClosedCessna 182A · Stratford, CTJun 3, 1965 · N2014G · Substantial damage NTSB NYC65F0212Accident · Serious injuriesClosedAeronca 7AC · Plymouth, CTMay 22, 1965 · N2615E · Substantial damage NTSB NYC65F0193Accident · No injuriesClosedErcoupe 415C · East Haven, CTMay 6, 1965 · N93991 · Substantial damage NTSB NYC65F0185Accident · No injuriesClosedPiper PA-23 · New Haven, CTApr 24, 1965 · N5604Y · Substantial damage NTSB NYC65F0103Accident · No injuriesClosedCessna 150 · Plainville, CTApr 6, 1965 · N6401T · Substantial damage NTSB NYC65F0114Accident · No injuriesClosedPiper PA-28 · New Haven, CTApr 3, 1965 · N6405W · Substantial damage NTSB NYC65F0056Accident · No injuriesClosedBeechraft 35-33 · Bethany, CTMar 7, 1965 · N928T · Substantial damage NTSB NYC65F0049Accident · No injuriesClosedPiper PA-22 · Willimantic, CTFeb 28, 1965 · N5538Z · Substantial damage NTSB NYC65F0027Accident · No injuriesClosedPiper PA22 · Danbury, CTFeb 15, 1965 · N5162Z · Substantial damage NTSB NYC65F0013Accident · No injuriesClosedPiper PA22 · Ansonia, CTFeb 14, 1965 · N1455A · Substantial damage NTSB NYC65F0020Accident · No injuriesClosedCessna 170B · Ansonia, CTFeb 13, 1965 · N8161A · Substantial damage NTSB UNK65X1404Accident · No injuriesClosedPiper PA22 · Woodstock, CTFeb 7, 1965 · N5989D · Substantial damage NTSB NYC65F0007Accident · No injuriesClosedCessna 180 · Roxbury, CTFeb 4, 1965 · N2961A · Substantial damage NTSB NYC65F0067Accident · No injuriesClosedCessna 172 · Bolton, CTFeb 1, 1965 · N7771U · Substantial damage NTSB NYC65F0021Accident · No injuriesClosedCessna 150 · Williamantic, CTJan 29, 1965 · N7348X · Substantial damage NTSB UNK65X1365Accident · No injuriesClosedPiper PA28 · Plainville, CTJan 28, 1965 · N6068W · Substantial damage NTSB UNK65X1350Accident · No injuriesClosedPiper PA23 · Windsor Locks, CTJan 26, 1965 · N4941P · Substantial damage NTSB UNK65X1332Accident · No injuriesClosedCommonwlth 185 · Meriden, CTJan 22, 1965 · N93250 · Substantial damage NTSB NYC65A0097Accident · Minor injuriesClosedSikorsky S61N · Stratford, CTJan 21, 1965 · N92866 · Substantial damage NTSB NYC65A0095Accident · Serious injuriesClosedConvair CV-440 · Windsor Lock, CTJan 18, 1965 · N4406 · No damage NTSB UNK65X1211Accident · No injuriesClosedCessna 150B · Thomaston, CTJan 1, 1965 · N7325X · Substantial damage NTSB UNK65X0973Accident · No injuriesClosedCessna 150 · Willimantic, CTDec 11, 1964 · N7990Z · Substantial damage NTSB UNK65X0887Accident · No injuriesClosedPiper PA28 · Waterbury, CTNov 29, 1964 · N7906W · Substantial damage