NTSB investigations: Cessna 150L, Outside the U.S.
15 cases on aircraft the registry lists as Cessna 150L. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1971 | 1 |
|---|---|
| 1972 | 2 |
| 1973 | 2 |
| 1974 | 1 |
| 1975 | 2 |
| 1977 | 1 |
| 1978 | 2 |
| 1984 | 1 |
| 1987 | 1 |
| 2002 | 1 |
| 2004 | 1 |
Latest cases
Query with SQL
duckdb -csv -c "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"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB FTW04WA058Accident · No injuriesForeign investigationCessna 150L · Santo Domingo, Dominican RepublicNTSB MIA02WA103Accident · No injuriesForeign investigationCessna 150L · Pinar Del Rio, CubaNTSB LAX87LA110Accident · 2 fatalLimited investigationFinal reportCessna 150L · Ayase, JapanDuring 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 LAX84RA248Accident · 2 fatalForeign investigationCessna 150L · Seoul, South KoreaNTSB UNK79X0101Accident · Minor injuriesClosedCessna 150 · Atsugi, JANTSB UNK78X0115Accident · Serious injuriesClosedCessna 150L · Kunsan, KSNTSB MIA770KT59Accident · No injuriesClosedCessna 150 · Canal Zone, St. Pierre & MiquelonNTSB OAK75DJY05Accident · Minor injuriesClosedCessna 150 · Clark Afb, RPNTSB OAK75DJY06Accident · Minor injuriesClosedCessna 150L · Manila, RPNTSB OAK75DJY04Accident · No injuriesClosedCessna 150 · Olongapo City, RPNTSB OAK74DJY09Accident · 2 fatalClosedCessna 150 · Tagaytay City, RPNTSB OAK73FJZ03Accident · Serious injuriesClosedCessna 150 · Kashima Isl, JANTSB MIA73OKT40Accident · No injuriesClosedCessna 150 · Neuvo Empradr, CanadaNTSB OAK73FJZ01Accident · No injuriesClosedCessna 150 · Misawa, JANTSB UNK71X0104Accident · 1 fatalClosedCessna 150L · New Providence, Burkina Faso