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 NYC72FNE36Accident · Minor injuriesClosedCvjetkovic CA-65 · Ansonia, CTMay 21, 1972 · N165CA · Destroyed NTSB NYC73FNE35Accident · Serious injuriesClosedCessna 150B · Union, CTMay 6, 1972 · N7348X · Destroyed NTSB NYC72AN139Accident · 1 fatalClosedBeech 95-E55 · Groton, CTMay 3, 1972 · N793Q · Destroyed NTSB NYC72FNE34Accident · Minor injuriesClosedAeronca 11AC · Easton, CTApr 21, 1972 · N85810 · Substantial damage NTSB NYC72AN128Accident · 1 fatalClosedCessna 185 · Tariffville, CTApr 13, 1972 · N5854T · Destroyed NTSB NYC72DNE32Accident · No injuriesClosedGlobe GC-1B · Plainville, CTMar 19, 1972 · N2306B · Substantial damage NTSB NYC72FNE31Accident · No injuriesClosedCessna 172C · Simsbury, CTMar 18, 1972 · N1501Y · Substantial damage NTSB NYC72AN110Accident · No injuriesClosedConvair 580 · Windsor Lcks, CTMar 11, 1972 · N5803 · Substantial damage NTSB NYC72FNE29Accident · No injuriesClosedPiper PA-28 · Hartford, CTFeb 29, 1972 · N1806J · Substantial damage NTSB NYC72FNE28Accident · Serious injuriesClosedCessna 182H · Bloomfield, CTFeb 28, 1972 · N2337X · Substantial damage NTSB NYC72FNE26Accident · No injuriesClosedBeech 100 · E.Hartford, CTFeb 23, 1972 · N101UA · Substantial damage NTSB NYC72FNE25Accident · No injuriesClosedPiper PA-28 · Stratford, CTFeb 21, 1972 · N5315L · Substantial damage NTSB NYC72DNE27Accident · No injuriesClosedCessna 172I · Groton, CTFeb 20, 1972 · N35479 · Substantial damage NTSB NYC72FNE23Accident · No injuriesClosedRepublic RC-3 · Danbury, CTFeb 1, 1972 · N6111K · Destroyed NTSB NYC72FNE24Accident · No injuriesClosedGlobe GC-1B · East Haven, CTJan 30, 1972 · N2372B · Substantial damage NTSB NYC72FNC22Accident · No injuriesClosedCessna 150 · Mid Haddam, CTJan 27, 1972 · N3991J · Substantial damage NTSB NYC72FNE19Accident · Minor injuriesClosedCessna 172F · Kent, CTDec 22, 1971 · N7857U · Substantial damage NTSB NYC72FNE20Accident · No injuriesClosedCessna 182L · Simsbury, CTDec 15, 1971 · N3366R · Destroyed NTSB NYC72FNE17Accident · No injuriesClosedCommonwlth 185 · Middlebury, CTDec 12, 1971 · N92914 · Substantial damage NTSB NYC72AN081Accident · 3 fatalClosedCessna 170 · Woodstock, CTDec 12, 1971 · N4016V · Substantial damage NTSB NYC72FNE16Accident · No injuriesClosedCessna 172D · Deep River, CTNov 14, 1971 · N8537X · Substantial damage NTSB NYC72FNE15Accident · No injuriesClosedAeronca 7DC · Oxford, CTNov 7, 1971 · N4493E · Substantial damage NTSB NYC72FNE13Accident · Minor injuriesClosedPiper J3C-65 · Durham, CTSep 29, 1971 · N88179 · Substantial damage NTSB NYC72FNE12Accident · Minor injuriesClosedBeech A-45 · Monroe, CTSep 19, 1971 · N450L · Substantial damage NTSB NYC72AN040Accident · No injuriesClosedBell 206A · Westport, CTSep 15, 1971 · N1409W · Substantial damage NTSB NYC72FNE09Accident · Minor injuriesClosedCessna 140A · Woodstock, CTSep 7, 1971 · N9622A · Substantial damage NTSB NYC72FNE10Accident · Minor injuriesClosedPiper PA-28 · Plainville, CTSep 4, 1971 · N1769T · Substantial damage NTSB NYC72FNE08Accident · Serious injuriesClosedPiper PA-28 · Danbury, CTAug 29, 1971 · N95409 · Destroyed NTSB NYC72AN029Accident · No injuriesClosedCessna 337D · Chester, CTAug 24, 1971 · N337LF · Substantial damage NTSB NYC72FNE06Accident · Minor injuriesClosedChampion 7EC · Sherman, CTAug 10, 1971 · N7520E · Substantial damage NTSB NYC72FNE04Accident · No injuriesClosedCessna 140 · Meriden, CTAug 8, 1971 · N2913N · Substantial damage NTSB NYC72FNE05Accident · No injuriesClosedBeech A23A · Oxford, CTAug 6, 1971 · N2326W · Substantial damage NTSB NYC72FNE03Accident · No injuriesClosedRotorway Scorpn · Westbrook, CTAug 1, 1971 · N8851 · Substantial damage NTSB NYC72AN011Accident · 2 fatalClosedPiper PA-30 · Madison, CTJul 26, 1971 · N643TT · Destroyed NTSB NYC72AN006Accident · Minor injuriesClosedDouglas DC-3 · Windsor Lks, CTJul 16, 1971 · N74844 · Substantial damage NTSB NYC72FNE02Accident · No injuriesClosedCommandaire 5C3 · Ellington, CTJul 15, 1971 · N925E · Substantial damage NTSB NYC71FNE42Accident · Minor injuriesClosedChampion 7KCAB · Oxford, CTJun 22, 1971 · N7500F · Substantial damage NTSB NYC71FNE46Accident · No injuriesClosedBrantly B-2A · Broad Brook, CTJun 16, 1971 · N6791D · Substantial damage NTSB NYC71DNE43Accident · Minor injuriesClosedCessna 172D · Danbury, CTJun 16, 1971 · N2733U · Substantial damage NTSB NYC71DNE40Accident · No injuriesClosedCessna 310 · Waterford, CTJun 13, 1971 · N5241A · Substantial damage NTSB NYC71DNE39Accident · No injuriesClosedPiper PA-28 · Plainville, CTJun 11, 1971 · N3981K · Substantial damage NTSB DCA71AZ009Accident · 28 fatalClosedConvair 580 · New Haven, CTJun 7, 1971 · N5832 · Destroyed NTSB NYC71FNE37Accident · 1 fatalClosedB.Jungmistr BU-133 · Plainville, CTJun 6, 1971 · N4767 · Destroyed NTSB NYC71IN115Incident · No injuriesClosedDouglas DC-9 · New Haven, CTJun 1, 1971 · N8924E · Minor damage NTSB NYC71FNE35Accident · No injuriesClosedBeech 95 · Willimantic, CTMay 29, 1971 · N8226D · Substantial damage NTSB NYC71DNE36Accident · Minor injuriesClosedCessna 172K · Willimantic, CTMay 29, 1971 · N7377G · Destroyed NTSB NYC71FNE34Accident · Minor injuriesClosedFlybaby 1A · Oxford, CTMay 20, 1971 · N3314 · Destroyed NTSB NYC71FNE33Accident · No injuriesClosedKitalina AFB · Waterford, CTMay 20, 1971 · N5577 · Substantial damage NTSB NYC71DNE31Accident · No injuriesClosedBeech A23-19 · Windsor Lks, CTApr 27, 1971 · N6949Q · Substantial damage NTSB NYC71DNE38Accident · No injuriesClosedCessna 172K · Hartford, CTApr 9, 1971 · N78638 · Substantial damage