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 NYC68F0403Accident · No injuriesClosedCessna 177 · Windsor Lock, CTMar 6, 1968 · N2980X · Substantial damage NTSB NYC68D0387Accident · No injuriesClosedPiper PA-24 · Stratford, CTFeb 23, 1968 · N870W · Substantial damage NTSB NYC68D0407Accident · No injuriesClosedCessna 182 · Plainville, CTFeb 15, 1968 · N2751Q · Substantial damage NTSB NYC68D0358Accident · No injuriesClosedCessna 210 · Hartford, CTJan 21, 1968 · N1854Z · Substantial damage NTSB NYC68D0327Accident · No injuriesClosedCessna 150 · Plainville, CTJan 6, 1968 · N3790J · Substantial damage NTSB NYC68F0322Accident · No injuriesClosedCessna 150G · Hartford, CTDec 20, 1967 · N3237J · Substantial damage NTSB NYC68D0310Accident · No injuriesClosedCessna 172 · Groton, CTDec 17, 1967 · N5329T · Substantial damage NTSB NYC68A0079Accident · 4 fatalClosedPiper PA-28 · Bridgeport, CTDec 16, 1967 · N9736J · Destroyed NTSB NYC68F0282Accident · No injuriesClosedCessna 150F · Plainville, CTNov 5, 1967 · N8218F · Substantial damage NTSB NYC68F0280Accident · Serious injuriesClosedCessna 150F · Plainville, CTNov 5, 1967 · N6694F · Substantial damage NTSB NYC68D0258Accident · No injuriesClosedBeech A23 · Burlington, CTOct 25, 1967 · N1421L · Substantial damage NTSB NYC68D0246Accident · No injuriesClosedCessna 182 · Windsor Lock, CTOct 23, 1967 · N2704Q · Substantial damage NTSB NYC68D0235Accident · Serious injuriesClosedAeronca 7CCM · Hartford, CTOct 13, 1967 · N1318V · Substantial damage NTSB NYC68D0245Accident · No injuriesClosedMooney M20B · Fairfield, CTSep 30, 1967 · N74514 · Substantial damage NTSB NYC68A0050Accident · No injuriesClosedPiper PA-23 · New London, CTSep 24, 1967 · N4900P · Substantial damage NTSB NYC68D0149Accident · Serious injuriesClosedCessna 172E · Ea.Hampton, CTSep 2, 1967 · N5308T · Substantial damage NTSB NYC68A0034Accident · No injuriesClosedSikorsky S-51 · Wndsor Locks, CTAug 29, 1967 · N13301 · Substantial damage NTSB NYC68F0159Accident · No injuriesClosedCessna 150E · Terryville, CTAug 20, 1967 · N4018U · Substantial damage NTSB NYC68F0147Accident · No injuriesClosedPiper PA-23 · Hartford, CTAug 17, 1967 · N4416P · Substantial damage NTSB NYC68D0163Accident · No injuriesClosedPiper PA-28 · East Haddam, CTAug 5, 1967 · N6079W · Substantial damage NTSB NYC68D0084Accident · No injuriesClosedPiper PA-12 · Monroe, CTAug 5, 1967 · N3177M · Substantial damage NTSB NYC68D0105Accident · No injuriesClosedCessna 182 · Canaan, CTAug 4, 1967 · N3094Q · Substantial damage NTSB NYC68A0023Accident · 4 fatalClosedCessna 182K · Trumbull, CTAug 4, 1967 · N3025Q · Destroyed NTSB NYC68D0062Accident · No injuriesClosedCorbin Ace D · Newton, CTJul 27, 1967 · N8751R · Substantial damage NTSB NYC68A0017Accident · 2 fatalClosedPiper PA-28 · Bridgeport, CTJul 27, 1967 · N7865W · Destroyed NTSB NYC68A0003Accident · 2 fatalClosedStinson 108-3 · Woodstock, CTJul 6, 1967 · N595C · Destroyed NTSB NYC68D0045Accident · Minor injuriesClosedCessna 150D · East Hampton, CTJul 4, 1967 · N5929T · Substantial damage NTSB NYC68D0054Accident · No injuriesClosedCessna 150 · Ellington, CTJul 2, 1967 · N2211J · Substantial damage NTSB NYC68D0056Accident · No injuriesClosedStearman PT-17 · Meriden, CTJul 1, 1967 · N1350M · Substantial damage NTSB NYC68D0012Accident · No injuriesClosedCessna 182 · Chester, CTJun 9, 1967 · N8967X · Substantial damage NTSB NYC67D0703Accident · No injuriesClosedBeech 35-B33 · Windsor Lks, CTJun 5, 1967 · N1589S · Substantial damage NTSB NYC67A0170Accident · 1 fatalClosedPiper PA-18S · Westbrook, CTMay 28, 1967 · N3901Z · Destroyed NTSB NYC67D0676Accident · No injuriesClosedPiper PA-12 · Burlington, CTMay 21, 1967 · N3840M · Substantial damage NTSB NYC67D0663Accident · No injuriesClosedPiper PA-28 · Plainville, CTMay 13, 1967 · N9068J · Substantial damage NTSB NYC67D0681Accident · No injuriesClosedCessna 150 · Plainville, CTMay 11, 1967 · N3790J · Substantial damage NTSB NYC67F0654Accident · No injuriesClosedCessna 310D · New Haven, CTApr 29, 1967 · N6980T · Substantial damage NTSB NYC67D0643Accident · No injuriesClosedPiper PA-30 · Woodstock, CTApr 21, 1967 · N7455Y · Substantial damage NTSB NYC67F0589Accident · No injuriesClosedCessna 172 · Plainville, CTApr 9, 1967 · N5519R · 2 aircraft · Substantial damage NTSB NYC67A0149Accident · No injuriesClosedBrantly B-2B · Burlington, CTApr 8, 1967 · N2191U · Substantial damage NTSB NYC67D0602Accident · No injuriesClosedCessna 172 · New Haven, CTApr 3, 1967 · N1592Y · Substantial damage NTSB NYC67F0593Accident · No injuriesClosedCessna 182F · Madison, CTApr 2, 1967 · N3335U · Substantial damage NTSB NYC67F0586Accident · No injuriesClosedCessna 337B · Windsor Loks, CTMar 30, 1967 · N5428S · Substantial damage NTSB NYC67D0575Accident · No injuriesClosedCessna 150 · Williamantic, CTMar 28, 1967 · N8896G · Substantial damage NTSB NYC67F0568Accident · No injuriesClosedCessna 150 · Simsbury, CTMar 20, 1967 · N8317J · Substantial damage NTSB NYC67D0559Accident · No injuriesClosedMooney M20E · Plainville, CTMar 20, 1967 · N9307M · Substantial damage NTSB NYC67F0566Accident · No injuriesClosedCessna 150G · Newtown, CTMar 19, 1967 · N3371J · Substantial damage NTSB NYC67D0546Accident · No injuriesClosedPiper PA-28 · Hartford, CTMar 16, 1967 · N9124W · Substantial damage NTSB NYC67D0526Accident · No injuriesClosedPiper PA-24 · Madison, CTFeb 22, 1967 · N6164P · Substantial damage NTSB NYC67F0527Accident · Serious injuriesClosedPiper PA-28 · Cheshire, CTFeb 21, 1967 · N6370R · Destroyed NTSB NYC67D0506Accident · No injuriesClosedBeech 23 · Danbury, CTFeb 5, 1967 · N5996S · Substantial damage