# NTSB investigations: Continental 0-300 series, CT

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB NYC03LA084](https://openairdocs.org/ntsb/NYC03LA084.md): Maule M4 · Danielson, CT · Accident · No injuries · Limited investigation · Final report · Apr 12, 2003 · N4714T · Substantial damage
  > The pilot's inadequate compensation for winds, and failure to maintain directional control. A factor in this accident was the crosswind condition.
- [NTSB IAD96FA057](https://openairdocs.org/ntsb/IAD96FA057.md): Cessna 172 · Barkhamsted, CT · Accident · 3 fatal · Field investigation · Final report · Apr 6, 1996 · N6234E · Destroyed
  > the CFI pilot/passenger's poor judgment which led to spatial disorientation and subsequent loss of control of the airplane. Factors involved in this accident were the night marginal visual flight conditions and continuing flight with a known nonfunctioning…
- [NTSB NYC80FNE07](https://openairdocs.org/ntsb/NYC80FNE07.md): Cessna 172 · Burlington, CT · Accident · No injuries · Closed · Dec 29, 1979 · N2416L · Substantial damage
- [NTSB NYC79FA104](https://openairdocs.org/ntsb/NYC79FA104.md): Cessna 172D · Greenwich, CT · Accident · 1 fatal · Closed · Sep 20, 1979 · N2331U · Destroyed
- [NTSB NYC72DNE32](https://openairdocs.org/ntsb/NYC72DNE32.md): Globe GC-1B · Plainville, CT · Accident · No injuries · Closed · Mar 19, 1972 · N2306B · Substantial damage
- [NTSB NYC72FNE31](https://openairdocs.org/ntsb/NYC72FNE31.md): Cessna 172C · Simsbury, CT · Accident · No injuries · Closed · Mar 18, 1972 · N1501Y · Substantial damage
- [NTSB NYC72FNE19](https://openairdocs.org/ntsb/NYC72FNE19.md): Cessna 172F · Kent, CT · Accident · Minor injuries · Closed · Dec 22, 1971 · N7857U · Substantial damage
- [NTSB NYC70DFM14](https://openairdocs.org/ntsb/NYC70DFM14.md): Cessna 172 · Stratford, CT · Accident · No injuries · Closed · May 29, 1970 · N7957U · Substantial damage
- [NTSB NYC69A0071](https://openairdocs.org/ntsb/NYC69A0071.md): Cessna 172 · Plainville, CT · Accident · No injuries · Closed · Jan 8, 1969 · N8198L · Substantial damage
- [NTSB NYC68D0310](https://openairdocs.org/ntsb/NYC68D0310.md): Cessna 172 · Groton, CT · Accident · No injuries · Closed · Dec 17, 1967 · N5329T · Substantial damage
- [NTSB NYC68D0149](https://openairdocs.org/ntsb/NYC68D0149.md): Cessna 172E · Ea.Hampton, CT · Accident · Serious injuries · Closed · Sep 2, 1967 · N5308T · Substantial damage
- [NTSB NYC67D0472](https://openairdocs.org/ntsb/NYC67D0472.md): Cessna 172 · Trumbull, CT · Accident · Minor injuries · Closed · Jan 22, 1967 · N8280U · Substantial damage
- [NTSB NYC67D0105](https://openairdocs.org/ntsb/NYC67D0105.md): Cessna 172 · Madison, CT · Accident · No injuries · Closed · Jul 17, 1966 · N3597S · Substantial damage
- [NTSB NYC67D0052](https://openairdocs.org/ntsb/NYC67D0052.md): Cessna 172 · Waterbury, CT · Accident · Minor injuries · Closed · Jul 10, 1966 · N6013R · Substantial damage
- [NTSB NYC67D0020](https://openairdocs.org/ntsb/NYC67D0020.md): Cessna 172 · Ansonia, CT · Accident · No injuries · Closed · Jun 9, 1966 · N3813L · Substantial damage
- [NTSB NYC66F0244](https://openairdocs.org/ntsb/NYC66F0244.md): Cessna 172 · Harwinton, CT · Accident · No injuries · Closed · Oct 3, 1965 · N7459T · Substantial damage
- [NTSB NYC66F0069](https://openairdocs.org/ntsb/NYC66F0069.md): Cessna 172F · E Killingly, CT · Accident · No injuries · Closed · Jul 13, 1965 · N5551R · Substantial damage
- [NTSB NYC65F0067](https://openairdocs.org/ntsb/NYC65F0067.md): Cessna 172 · Bolton, CT · Accident · No injuries · Closed · Feb 1, 1965 · N7771U · Substantial damage
- [NTSB UNK64X3839](https://openairdocs.org/ntsb/UNK64X3839.md): Cessna 172 · Madison, CT · Accident · No injuries · Closed · Sep 7, 1964 · N6471E · Substantial damage
- [NTSB UNK64X1352](https://openairdocs.org/ntsb/UNK64X1352.md): Cessna 172 · Woodstock, CT · Accident · No injuries · Closed · Apr 17, 1964 · N7660X · Substantial damage

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17022'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=17022&state=CT

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.