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 NYC70F0123Accident · Minor injuriesClosedPiper PA-30 · Windsr Locks, CTAug 5, 1969 · N448Q · Substantial damage NTSB NYC70F0054Accident · No injuriesClosedPiper PA-17 · Madison, CTJul 9, 1969 · N4811H · Substantial damage NTSB NYC70F0052Accident · Minor injuriesClosedCessna 177 · Middletown, CTJun 27, 1969 · N29677 · Substantial damage NTSB NYC69A0111Accident · 9 fatalClosedPiper PA-23 · Waterford, CTJun 14, 1969 · N4101P · 2 aircraft · Destroyed NTSB NYC69A0107Accident · 3 fatalClosedPiper PA-32 · Greenwich, CTJun 2, 1969 · N3375W · Destroyed NTSB NYC69F0471Accident · Minor injuriesClosedCessna 177 · Unionville, CTMay 31, 1969 · N2296Y · Substantial damage NTSB NYC69D0467Accident · No injuriesClosedCessna 150 · Hartford, CTMay 12, 1969 · N8035S · Substantial damage NTSB NYC69D0468Accident · Minor injuriesClosedPiper J3C-65 · New Milford, CTMay 4, 1969 · N3314N · Substantial damage NTSB NYC69D0430Accident · No injuriesClosedCessna 150 · Southbury, CTApr 28, 1969 · N6703F · Substantial damage NTSB NYC69D0422Accident · Minor injuriesClosedCessna 150 · S Woodstock, CTApr 26, 1969 · N64555 · Substantial damage NTSB NYC69D0412Accident · No injuriesClosedPiper PA-28 · Danbury, CTApr 21, 1969 · N7243J · Substantial damage NTSB NYC69D0416Accident · No injuriesClosedCessna 206 · Roxbury, CTApr 17, 1969 · N5269U · Substantial damage NTSB NYC69D0409Accident · No injuriesClosedPiper PA-22 · Bridgeport, CTApr 6, 1969 · N4672Z · Substantial damage NTSB NYC69D0378Accident · No injuriesClosedCessna 182 · Burlington, CTMar 28, 1969 · N3672U · Substantial damage NTSB NYC69F0385Accident · Serious injuriesClosedCessna U206 · East Granby, CTMar 20, 1969 · N8019Z · Destroyed NTSB NYC69D0368Accident · No injuriesClosedPiper PA-28 · Danielson, CTMar 9, 1969 · N8477R · Substantial damage NTSB NYC69F0348Accident · No injuriesClosedAero Comdr 100A · Groton, CTFeb 22, 1969 · N5555M · Substantial damage NTSB NYC69D0330Accident · No injuriesClosedStitts Plaboy · Danbury, CTJan 26, 1969 · N339Y · Substantial damage NTSB NYC69D0316Accident · Minor injuriesClosedChampion 7ECA · Simsbury, CTJan 12, 1969 · N8348V · Substantial damage NTSB NYC69A0071Accident · No injuriesClosedCessna 172 · Plainville, CTJan 8, 1969 · N8198L · Substantial damage NTSB NYC69D0307Accident · No injuriesClosedPiper PA-28 · Groton, CTJan 4, 1969 · N6971W · Substantial damage NTSB NYC69D0293Accident · No injuriesClosedCessna 140 · Danbury, CTDec 31, 1968 · N2208V · Substantial damage NTSB NYC69F0301Accident · No injuriesClosedAeronca 11AC · Burlington, CTDec 27, 1968 · N9702E · Substantial damage NTSB NYC69F0295Accident · No injuriesClosedBeech 35-B33 · Meriden, CTDec 25, 1968 · N1783G · Substantial damage NTSB NYC69D0275Accident · Minor injuriesClosedPiper PA-28 · Chester, CTNov 28, 1968 · N8891W · Substantial damage NTSB NYC69D0263Accident · No injuriesClosedCessna 150E · Hartford, CTNov 21, 1968 · N4018U · Substantial damage NTSB NYC69F0252Accident · Serious injuriesClosedPiper PA-28 · Glastonbury, CTOct 30, 1968 · N3728K · Substantial damage NTSB NYC69D0213Accident · No injuriesClosedPiper PA-28 · E Hampton, CTSep 29, 1968 · N7280J · Substantial damage NTSB NYC69A0039Accident · 2 fatalClosedPiper J3C-65 · North Canaan, CTSep 22, 1968 · N70708 · Destroyed NTSB NYC69F0165Accident · Serious injuriesClosedBeech 23 · Danbury, CTSep 2, 1968 · N8727M · Destroyed NTSB NYC69D0160Accident · Minor injuriesClosedPiper J3C-65 · Woodstock, CTSep 1, 1968 · N42392 · Substantial damage NTSB NYC69D0096Accident · No injuriesClosedAlon A-2 · Ellington, CTAug 2, 1968 · N5608F · Substantial damage NTSB NYC69A0014Accident · No injuriesClosedPiper PA-28 · East Hampton, CTAug 1, 1968 · N9311J · Substantial damage NTSB NYC69A0012Accident · 1 fatalClosedCessna 150 · East Hampton, CTJul 31, 1968 · N8121S · Destroyed NTSB NYC69D0095Accident · No injuriesClosedPiper PA-28 · Ansonia, CTJul 24, 1968 · N5257W · Substantial damage NTSB NYC69D0121Accident · No injuriesClosedBeech B95A · Stratford, CTJul 22, 1968 · N1383Z · Substantial damage NTSB NYC69F0078Accident · No injuriesClosedPiper PA-28 · Danbury, CTJul 7, 1968 · N4397J · 2 aircraft · Substantial damage NTSB NYC68A0137Accident · 2 fatalClosedCessna 411 · Groton, CTJun 17, 1968 · N4955T · Destroyed NTSB NYC69F0033Accident · Serious injuriesClosedPiper PA-28 · Branford, CTJun 9, 1968 · N4455J · Destroyed NTSB NYC68F0502Accident · No injuriesClosedCessna 150 · Torrington, CTJun 7, 1968 · N3992U · Substantial damage NTSB NYC68F0506Accident · Serious injuriesClosedCessna 150 · Mansfield, CTJun 5, 1968 · N8112S · Substantial damage NTSB NYC69F0011Accident · Minor injuriesClosedBeech C-45H · Hartford, CTJun 3, 1968 · N4000Y · Destroyed NTSB NYC68A0127Accident · 1 fatalClosedCessna 140 · Woodstock, CTJun 3, 1968 · N76263 · Destroyed NTSB NYC68A0122Accident · 4 fatalClosedNavion A · Greenwich, CTMay 26, 1968 · N4918K · Destroyed NTSB NYC68D0479Accident · No injuriesClosedCessna 172 · East Windsor, CTApr 28, 1968 · N6882A · Substantial damage NTSB NYC68F0446Accident · No injuriesClosedPiper PA-23 · Windsor Lks, CTApr 14, 1968 · N4329Y · Substantial damage NTSB NYC68D0432Accident · No injuriesClosedPiper PA-28 · Waterford, CTApr 8, 1968 · N9245J · Substantial damage NTSB NYC68D0426Accident · No injuriesClosedCessna 150 · Thompson, CTApr 2, 1968 · N8345J · Substantial damage NTSB NYC68D0422Accident · No injuriesClosedBeech A-23 · Stratford, CTMar 30, 1968 · N1426L · Substantial damage NTSB NYC68A0112Accident · 1 fatalClosedBeech 95-B55 · Windsor Lock, CTMar 25, 1968 · N3030Q · Destroyed