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 NYC74FNE17Accident · No injuriesClosedCessna 140 · Harwinton, CTApr 17, 1974 · N76131 · Substantial damage 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 NTSB NYC73AN078Accident · 2 fatalClosedChampion 7KCAB · Monroe, CTDec 3, 1972 · N7562F · Destroyed NTSB NYC73FNE09Accident · Minor injuriesClosedPiper PA-22 · Oxford, CTOct 3, 1972 · N5840D · Substantial damage NTSB NYC73FNE08Accident · Serious injuriesClosedCessna 150J · Madison, CTSep 9, 1972 · N61060 · Destroyed NTSB NYC73FNE10Accident · Serious injuriesClosedGage B8MW · Milford, CTSep 1, 1972 · N4789 · Substantial damage NTSB NYC73FNE07Accident · Serious injuriesClosedCessna 150J · Waterford, CTAug 25, 1972 · N3045J · Destroyed NTSB NYC73DNE06Accident · No injuriesClosedCessna 182P · Bridgeport, CTAug 11, 1972 · N7341Q · Substantial damage NTSB NYC73AN022Accident · 1 fatalClosedRobertson 182K · Orange, CTAug 2, 1972 · N2676R · Destroyed NTSB NYC73AN021Accident · No injuriesClosedBell 206A · Rocky Hill, CTAug 2, 1972 · N550JA · Substantial damage NTSB NYC73DNE05Accident · No injuriesClosedCessna 150G · Ansonia, CTAug 1, 1972 · N8514J · Substantial damage NTSB NYC73FNE04Accident · No injuriesClosedCessna 140 · Waterford, CTJul 27, 1972 · N3572V · Substantial damage NTSB NYC73AN013Accident · Serious injuriesClosedBoeing 707 · Windsor Lock, CTJul 18, 1972 · N8705T · No damage NTSB NYC73FNE01Accident · No injuriesClosedCessna 150J · Hartford, CTJul 5, 1972 · N51343 · Substantial damage NTSB NYC72FNE38Accident · No injuriesClosedBeech M35 · Danielson, CTJun 27, 1972 · N329Z · Substantial damage NTSB NYC72FNE37Accident · No injuriesClosedCessna 310F · Windsor Lock, CTJun 2, 1972 · N6726X · Substantial damage NTSB NYC73FNE12Accident · No injuriesClosedPiper PA-18 · New Milford, CTMay 23, 1972 · N1361A · Destroyed