# NTSB investigations: Cessna T303, MA

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 GAA18CA134](https://openairdocs.org/ntsb/GAA18CA134.md): Cessna T303 · Great Barrington, MA · Accident · No injuries · Data collection · Final report · Feb 4, 2018 · N303TL · Substantial damage
  > The pilot’s failure to see the taxiway when returning to the ramp from the snow-covered runway, which resulted in the airplane rolling down an embankment.
- [NTSB NYC88LA091](https://openairdocs.org/ntsb/NYC88LA091.md): Cessna 303 · Hyannis, MA · Accident · No injuries · Limited investigation · Final report · Feb 3, 1988 · N5461V · Substantial damage
  > The Cessna 303 broke out of the clouds and made a long landing on a 5567 ft runway. Tire marks showed that the aircraft touched down with less than 2000 ft of runway remaining. The landing runway was 24 and the winds were from 360 degrees at 8 KTS. The runway…

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

This list as a web page: https://openairdocs.org/ntsb?model=2073820&state=MA

---
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.