# NTSB investigations: Cessna 150L, 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 FTW04WA058](https://openairdocs.org/ntsb/FTW04WA058.md): Cessna 150L · Santo Domingo, Dominican Republic · Accident · No injuries · Foreign investigation · Jan 6, 2004 · N16035 · Substantial damage
- [NTSB MIA02WA103](https://openairdocs.org/ntsb/MIA02WA103.md): Cessna 150L · Pinar Del Rio, Cuba · Accident · No injuries · Foreign investigation · May 21, 2002 · N5332Q · Substantial damage
- [NTSB LAX87LA110](https://openairdocs.org/ntsb/LAX87LA110.md): Cessna 150L · Ayase, Japan · Accident · 2 fatal · Limited investigation · Final report · Feb 7, 1987 · N6797G · Substantial damage
  > During an instructional flight, just after take-off the instructor was heard to transmit over the radio 'request emergency landing.' At an altitude of approximately 15O feet AGL the aircraft was observed to pitch up then nosed down in a shallow left turn. The…
- [NTSB LAX84RA248](https://openairdocs.org/ntsb/LAX84RA248.md): Cessna 150L · Seoul, South Korea · Accident · 2 fatal · Foreign investigation · Mar 9, 1984 · N6764G · Destroyed
- [NTSB UNK79X0101](https://openairdocs.org/ntsb/UNK79X0101.md): Cessna 150 · Atsugi, JA · Accident · Minor injuries · Closed · Nov 7, 1978 · N6963G · Destroyed
- [NTSB UNK78X0115](https://openairdocs.org/ntsb/UNK78X0115.md): Cessna 150L · Kunsan, KS · Accident · Serious injuries · Closed · Apr 14, 1978 · N6940G · Substantial damage
- [NTSB MIA770KT59](https://openairdocs.org/ntsb/MIA770KT59.md): Cessna 150 · Canal Zone, St. Pierre & Miquelon · Accident · No injuries · Closed · Jul 23, 1977 · N1320Q · Substantial damage
- [NTSB OAK75DJY05](https://openairdocs.org/ntsb/OAK75DJY05.md): Cessna 150 · Clark Afb, RP · Accident · Minor injuries · Closed · May 24, 1975 · N1682Q · Substantial damage
- [NTSB OAK75DJY06](https://openairdocs.org/ntsb/OAK75DJY06.md): Cessna 150L · Manila, RP · Accident · Minor injuries · Closed · Apr 29, 1975 · N6838G · Destroyed
- [NTSB OAK75DJY04](https://openairdocs.org/ntsb/OAK75DJY04.md): Cessna 150 · Olongapo City, RP · Accident · No injuries · Closed · Dec 9, 1974 · N6838G · Substantial damage
- [NTSB OAK74DJY09](https://openairdocs.org/ntsb/OAK74DJY09.md): Cessna 150 · Tagaytay City, RP · Accident · 2 fatal · Closed · Dec 22, 1973 · N21963 · Destroyed
- [NTSB OAK73FJZ03](https://openairdocs.org/ntsb/OAK73FJZ03.md): Cessna 150 · Kashima Isl, JA · Accident · Serious injuries · Closed · Jan 29, 1973 · N6772G · Substantial damage
- [NTSB MIA73OKT40](https://openairdocs.org/ntsb/MIA73OKT40.md): Cessna 150 · Neuvo Empradr, Canada · Accident · No injuries · Closed · Dec 8, 1972 · N6602G · Substantial damage
- [NTSB OAK73FJZ01](https://openairdocs.org/ntsb/OAK73FJZ01.md): Cessna 150 · Misawa, JA · Accident · No injuries · Closed · Aug 2, 1972 · N6937G · Substantial damage
- [NTSB UNK71X0104](https://openairdocs.org/ntsb/UNK71X0104.md): Cessna 150L · New Providence, Burkina Faso · Accident · 1 fatal · Closed · Jan 31, 1971 · N6506G · Destroyed

## 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 ('2071826'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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