# NTSB investigations: Cessna 172F, 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 GAA23WA202](https://openairdocs.org/ntsb/GAA23WA202.md): Cessna 150H · Cayo District, Belize · Incident · No injuries · Class 5 · Foreign · Jul 9, 2023 · N8473U · Minor damage
- [NTSB MIA98WA203](https://openairdocs.org/ntsb/MIA98WA203.md): Cessna 172F · Grand Turk, United Kingdom · Accident · Serious injuries · Foreign investigation · Jul 18, 1998 · N5682R · No damage
- [NTSB MIA93WA201](https://openairdocs.org/ntsb/MIA93WA201.md): Cessna 172F · Long Island, Turks & Caicos Islands · Accident · Minor injuries · Foreign investigation · Sep 25, 1993 · N8676U · Destroyed
- [NTSB OAK77OA003](https://openairdocs.org/ntsb/OAK77OA003.md): Cessna 172F · Bontoc, RP · Accident · Serious injuries · Closed · Feb 4, 1977 · N5201F · Destroyed
- [NTSB FTW75OQD31](https://openairdocs.org/ntsb/FTW75OQD31.md): Cessna 172 · Agua Caliente, Mexico · Accident · Minor injuries · Closed · Jun 27, 1975 · N8444U · Substantial damage
- [NTSB MIA73OM112](https://openairdocs.org/ntsb/MIA73OM112.md): Cessna 172 · Hope Bay, Burkina Faso · Accident · No injuries · Closed · Jun 18, 1973 · N5366R · No damage
- [NTSB OAK72DJY09](https://openairdocs.org/ntsb/OAK72DJY09-201430.md): Cessna 172 · Castillejos, RP · Accident · No injuries · Closed · Feb 12, 1972 · N8422U · Substantial damage
- [NTSB OAK72DJY03](https://openairdocs.org/ntsb/OAK72DJY03.md): Cessna 172 · Cubi Point, RP · Accident · No injuries · Closed · May 6, 1971 · N8841U · Substantial damage
- [NTSB FTW71DRG57](https://openairdocs.org/ntsb/FTW71DRG57.md): Cessna 172 · San Cristobal, Mexico · Accident · Serious injuries · Closed · Nov 29, 1970 · N8701U · Substantial damage
- [NTSB UNK67X0133](https://openairdocs.org/ntsb/UNK67X0133.md): Cessna 172 · Holland Ldg, Canada · Accident · 1 fatal · Closed · Jul 1, 1967 · N8706U · Substantial damage
- [NTSB UNK66X0150](https://openairdocs.org/ntsb/UNK66X0150.md): Cessna 172 · Perrault Flls, Canada · Accident · No injuries · Closed · Jun 22, 1966 · N8116U · Destroyed
- [NTSB FTW66D0689](https://openairdocs.org/ntsb/FTW66D0689.md): Cessna 172 · Prto Lobos, Mexico · Accident · No injuries · Closed · Apr 8, 1966 · N8305U · 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 ('2072414'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072414&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.