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 NYC78FA046Accident · 1 fatalClosedPiper PA-28 · Danbury, CTApr 29, 1978 · N7126W · Destroyed NTSB NYC78FNE18Accident · No injuriesClosedCessna 177 · Hartford, CTApr 12, 1978 · N42118 · Substantial damage NTSB NYC78FNE17Accident · No injuriesClosedCessna 172M · East Windsor, CTApr 1, 1978 · N12219 · Substantial damage NTSB NYC78FNE16Accident · Serious injuriesClosedPiper PA-28R · Oxford, CTMar 31, 1978 · N47568 · Destroyed NTSB NYC78FNE15Accident · Serious injuriesClosedBeech 24R · Madson, CTMar 24, 1978 · N2186W · Substantial damage NTSB NYC78FNE10Accident · Minor injuriesClosedElci JD2FF · Waterford, CTFeb 26, 1978 · N776Y · Substantial damage NTSB NYC78FNE09Accident · No injuriesClosedPiper PA-32 · Meriden, CTFeb 23, 1978 · N32919 · Substantial damage NTSB NYC78FA027Accident · 1 fatalClosedPiper PA-32R · Danbury, CTFeb 10, 1978 · N47574 · Destroyed NTSB NYC78FNE06Accident · No injuriesClosedPiper PA-28 · Stratford, CTJan 29, 1978 · N7906W · Substantial damage NTSB NYC78FNE05Accident · No injuriesClosedPiper PA-28R · Ellington, CTJan 22, 1978 · N7445J · Substantial damage NTSB NYC78FNE04Accident · No injuriesClosedCessna 177 · Oxford, CTDec 29, 1977 · N2293Y · Substantial damage NTSB NYC78FNE03Accident · Serious injuriesClosedMooney M20 · New Haven, CTDec 26, 1977 · N6806V · Substantial damage NTSB NYC78FA016Accident · 1 fatalClosedPiper PA-28 · Brooklyn, CTDec 26, 1977 · N713FL · Substantial damage NTSB NYC78FA015Accident · 1 fatalClosedBeagle B206 · Greenwich, CTDec 20, 1977 · N1008B · Destroyed NTSB NYC78FA014Accident · No injuriesClosedLearjet 35 · Groton, CTDec 14, 1977 · N971H · Substantial damage NTSB NYC77FNE36Accident · No injuriesClosedPiper PA-28 · Simsbury, CTSep 19, 1977 · N5425F · Substantial damage NTSB NYC77FNE35Accident · Minor injuriesClosedCessna 177R · Stratford, CTSep 9, 1977 · N34095 · Substantial damage NTSB NYC77FA090Accident · 2 fatalClosedPiper PA-28R · Greenwich, CTAug 31, 1977 · N3960X · Destroyed NTSB NYC77FNE33Accident · No injuriesClosedCessna 180 · Waterford, CTAug 25, 1977 · N1596C · Destroyed NTSB NYC77FA078Accident · 2 fatalClosedBeagle B.206S · Westport, CTAug 11, 1977 · N850EX · Destroyed NTSB NYC77FNE32Accident · Minor injuriesClosedCessna 150 · Enfield, CTJul 25, 1977 · N1555Q · Substantial damage NTSB NYC77FNE28Accident · Serious injuriesClosedHebel B-1 · Killingworth, CTJul 2, 1977 · N1BF · Minor damage NTSB NYC77FNE27Accident · Minor injuriesClosedMooney M20C · Portland, CTJun 26, 1977 · N6928N · Substantial damage NTSB NYC77FNE24Accident · No injuriesClosedCessna 120 · Woodbridge, CTJun 26, 1977 · N1825V · Substantial damage NTSB NYC77FNE26Accident · Serious injuriesClosedBeech C23 · East Haddam, CTJun 24, 1977 · N1921L · Destroyed NTSB NYC77FNE23Accident · No injuriesClosedCessna 172M · Plainville, CTJun 19, 1977 · N9574H · Substantial damage NTSB NYC77FNE20Accident · No injuriesClosedPiper PA-28 · Milford, CTMay 22, 1977 · N9937W · Substantial damage NTSB NYC77FNE18Accident · Minor injuriesClosedPiper J3 · Fairfield, CTMay 16, 1977 · N6661H · Substantial damage NTSB NYC77FA038Accident · 1 fatalClosedPiper PA-23 · Weathersfield, CTApr 13, 1977 · N4483P · Destroyed NTSB NYC77FA051Accident · No injuriesClosedAero Comdr 500B · Bridgeport, CTApr 12, 1977 · N471A · 2 aircraft · Substantial damage NTSB NYC77FNE13Accident · No injuriesClosedCessna 172 · Chester, CTApr 8, 1977 · N9920Q · Substantial damage NTSB NYC77FNE14Accident · No injuriesClosedMitsubishi MU-2B · Bridgeport, CTApr 6, 1977 · N234BC · Substantial damage NTSB NYC77FNE11Accident · Minor injuriesClosedCessna 150M · Danbury, CTMar 27, 1977 · N3686V · Substantial damage NTSB NYC77FNE09Accident · No injuriesClosedPiper PA-32 · Plainville, CTMar 1, 1977 · N1458T · Substantial damage NTSB NYC77FNE29Accident · No injuriesClosedCessna 150 · North Canaan, CTFeb 7, 1977 · N6930G · Substantial damage NTSB NYC77FNE08Accident · No injuriesClosedTed Smith 601P · Meriden, CTFeb 5, 1977 · N1WC · Substantial damage NTSB NYC77FNE07Accident · Serious injuriesClosedCessna 177 · Danbury, CTJan 16, 1977 · N2288Y · Substantial damage NTSB NYC77FNE06Accident · No injuriesClosedPiper PA-22 · East Haddam, CTNov 15, 1976 · N2947P · Substantial damage NTSB NYC77FNE05Accident · Serious injuriesClosedCessna 150 · Meriden, CTNov 6, 1976 · N63562 · Destroyed NTSB NYC76IA006Incident · No injuriesClosedPiper PA-23 · Windsor Locks, CTOct 30, 1976 · N5670Y · No damage NTSB NYC77FNE03Accident · Minor injuriesClosedCessna 210E · Burlington, CTOct 26, 1976 · N4985U · Substantial damage NTSB NYC77FNE04Accident · No injuriesClosedLuscombe 8A · Burlington, CTOct 22, 1976 · N1170K · Substantial damage NTSB NYC77FNE01Accident · Minor injuriesClosedLapointe UP-2 · Williamantic, CTOct 4, 1976 · N76DL · Substantial damage NTSB NYC76FNE34Accident · Minor injuriesClosedGrum Amer AA-1A · Voluntown, CTSep 3, 1976 · N9333L · Destroyed NTSB NYC76FNE32Accident · No injuriesClosedCessna 150 · Ellington, CTAug 16, 1976 · N6272G · Substantial damage NTSB NYC76AN110Accident · 1 fatalClosedPiper PA-22 · Harwinton, CTJul 9, 1976 · N9981D · Destroyed NTSB NYC76FNE30Accident · 1 fatalClosedSchweizer SGS126 · Watertown, CTJul 5, 1976 · N2646H · Destroyed NTSB NYC76FNE26Accident · No injuriesClosedCessna 182E · Ellington, CTJun 27, 1976 · N3056Y · Substantial damage NTSB NYC76FNE25Accident · No injuriesClosedBeech E18S · Simsbury, CTJun 24, 1976 · N911E · Substantial damage NTSB NYC76FNE23Accident · Minor injuriesClosedTaylorcraft BC12-D · Norfolk, CTJun 6, 1976 · N95148 · Substantial damage