# NTSB investigations: Cessna 172M, Outside the U.S.

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 ANC20CA014](https://openairdocs.org/ntsb/ANC20CA014.md): Cessna 172 · Tokyo, Japan · Accident · No injuries · Data collection · Final report · Dec 15, 2019 · N22905 · Substantial damage
  > The airplane’s encounter with prop wash while taxiing behind a larger airplane that was conducting a high-power engine run on the same taxiway. Contributing to the accident was the air traffic controller’s failure to inform the smaller airplane’s pilot about…
- [NTSB CEN18WA399](https://openairdocs.org/ntsb/CEN18WA399.md): Cessna 172 · Hamilton, Bermuda · Accident · Minor injuries · Foreign investigation · Apr 30, 2018 · N9085H · Substantial damage
  > On April 30, 2018, about 2045 universal coordinated time (UTC), a Cessna 172 M airplane, N9085H, was substantially damaged during a landing at the L. F. Wade International Airport, near Hamilton, Bermuda. The pilot sustained minor injuries.The accident…
- [NTSB ERA15LA091](https://openairdocs.org/ntsb/ERA15LA091.md): Cessna 172M · South Bimini, Bahamas · Accident · Minor injuries · Limited investigation · Final report · Dec 22, 2014 · N12182 · Substantial damage
  > The total loss of engine power for reasons that could not be determined because examination of the engine did not reveal any anomalies that would have precluded normal operation, which resulted in a subsequent ditching in the ocean.
- [NTSB SEA00WA042](https://openairdocs.org/ntsb/SEA00WA042.md): Cessna 172M · Squamish, Canada · Accident · No injuries · Foreign investigation · Jan 23, 2000 · N1673V · Substantial damage
- [NTSB MIA99WA082](https://openairdocs.org/ntsb/MIA99WA082.md): Cessna 172M · Rum Cay, Bahamas · Accident · No injuries · Foreign investigation · Feb 12, 1999 · N61745 · Substantial damage
- [NTSB ATL99WA010](https://openairdocs.org/ntsb/ATL99WA010.md): Cessna 172M · Freeport, Bahamas · Accident · 4 fatal · Foreign investigation · Oct 10, 1998 · N9728H · Substantial damage
- [NTSB NYC95WA097](https://openairdocs.org/ntsb/NYC95WA097.md): Cessna 172M · St. Johns, Canada · Accident · 1 fatal · Foreign investigation · Apr 24, 1995 · N31083 · Destroyed
- [NTSB MIA93WA008](https://openairdocs.org/ntsb/MIA93WA008.md): Cessna 172M · Mayaguana Isl, Bahamas · Accident · No injuries · Foreign investigation · Oct 20, 1992 · N9288H · Substantial damage
- [NTSB MIA89WA222](https://openairdocs.org/ntsb/MIA89WA222.md): Cessna 172M · Grand Turk Isl., Turks & Caicos Islands · Accident · No injuries · Foreign investigation · Aug 14, 1989 · N12634 · Destroyed
- [NTSB UNK78X0127](https://openairdocs.org/ntsb/UNK78X0127.md): Cessna 172 · Gamboa, St. Pierre & Miquelon · Accident · No injuries · Closed · Jul 8, 1978 · N64089 · Substantial damage
- [NTSB MIA780KT40](https://openairdocs.org/ntsb/MIA780KT40.md): Cessna 172 · Cay Verde, Burkina Faso · Accident · No injuries · Closed · Jan 24, 1978 · N9391H · Substantial damage
- [NTSB MKC760K002](https://openairdocs.org/ntsb/MKC760K002.md): Cessna 172 · Trout Lake, Canada · Accident · Serious injuries · Closed · Aug 28, 1975 · N5166H · Destroyed
- [NTSB LAX73OL012](https://openairdocs.org/ntsb/LAX73OL012.md): Cessna 172M · San Luis, Mexico · Accident · No injuries · Closed · Apr 5, 1973 · N19874 · 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."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 ('2072418'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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