Skip to content

NTSB investigations: Cessna 150F, NV

26 cases on aircraft the registry lists as Cessna 150F. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19662026

Where

Latest cases

Query with 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" = 'NV' 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 ('2071814')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"eventStateOrRegion\" = 'NV' 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 ('2071814'))
  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."eventStateOrRegion" = 'NV' 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 ('2071814'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 WPR14CA069Accident · Minor injuriesData collectionFinal reportCessna 150F · Henderson, NVThe flight crew's improper in-flight fuel planning lead to fuel exhaustion, which resulted in a complete loss of engine power.Dec 14, 2013 · N7015F · Substantial damage NTSB LAX82FXQ07Accident · 1 fatalFinal reportCessna 150 · Wadsworth, NVWhile flying over the truckee river on a local flight, the left wing of the aircraft struck a group of five powerlines. The aircraft then impacted the water in a nose down attitude. It was carried downstream about 100 yards by the current before coming to…Apr 17, 1982 · N7820F · Destroyed NTSB LAX82DXQ01Accident · No injuriesClosedCessna 150 · Minden, NVNov 10, 1981 · N8436G · Destroyed NTSB LAX80FVW11Accident · Serious injuriesClosedCessna 150 · Searchlight, NVJan 23, 1980 · N6944F · Substantial damage NTSB OAK76FXQ53Accident · No injuriesClosedCessna 150 · Reno, NVJun 30, 1976 · N8061S · Substantial damage NTSB OAK76FXQ19Accident · Minor injuriesClosedCessna 150 · Reno, NVOct 15, 1975 · N8941S · Substantial damage NTSB OAK74FVW24Accident · Minor injuriesClosedCessna 150F · Henderson, NVJun 22, 1974 · N7119F · Substantial damage NTSB OAK73FVW24Accident · Minor injuriesClosedCessna 150F · Jean, NVJun 24, 1973 · N3533L · Substantial damage NTSB OAK73FVW01Accident · No injuriesClosedCessna 150F · Las Vegas, NVJul 3, 1972 · N3533L · Substantial damage NTSB OAK72FXQ32Accident · No injuriesClosedCessna 210 · Winnemucca, NVMay 13, 1972 · N6513F · Substantial damage NTSB OAK72DXQ30Accident · No injuriesClosedCessna 150 · Ely, NVMay 3, 1972 · N6882F · Substantial damage NTSB OAK70FVW13Accident · No injuriesClosedCessna 150 · Las Vegas, NVMay 11, 1970 · N8277F · Substantial damage NTSB OAK70A0005Accident · 2 fatalClosedCessna 150F · Las Vegas, NVJul 21, 1969 · N3583L · Destroyed NTSB OAK68A0022Accident · 2 fatalClosedCessna 150 · Boulder City, NVAug 27, 1967 · N7805F · Destroyed NTSB OAK68D0141Accident · No injuriesClosedCessna 150 · Mountain City, NVAug 2, 1967 · N6406F · Substantial damage NTSB OAK68D0219Accident · No injuriesClosedCessng 150 · Reno, NVJul 27, 1967 · N6742F · Substantial damage NTSB OAK68D0103Accident · No injuriesClosedCessna 150 · Minden, NVJun 29, 1967 · N8286S · Substantial damage NTSB OAK67D0282Accident · No injuriesClosedCessna 150 · Boulder City, NVFeb 11, 1967 · N7805F · Substantial damage NTSB OAK67D0312Accident · No injuriesClosedCessna 150 · Minden, NVFeb 3, 1967 · N6770F · Substantial damage NTSB OAK67D0220Accident · No injuriesClosedCessna 150 · Reno, NVJan 9, 1967 · N6965F · Substantial damage NTSB OAK67F0194Accident · No injuriesClosedCessna 150 · Minden, NVDec 11, 1966 · N6770F · Substantial damage NTSB OAK67D0149Accident · No injuriesClosedCessna 150 · Minden, NVOct 26, 1966 · N6793F · Substantial damage NTSB OAK67D0075Accident · No injuriesClosedCessna 150 · Minden, NVAug 23, 1966 · N8286S · Substantial damage NTSB OAK67F0070Accident · No injuriesClosedCessna 150 · Minden, NVJul 29, 1966 · N3054X · 2 aircraft · Substantial damage NTSB OAK67A0006Accident · 2 fatalClosedCessna 150 · Minden, NVJul 15, 1966 · N8702S · Destroyed NTSB LAX66F0258Accident · No injuriesClosedCessna 150 · Reno, NVFeb 28, 1966 · N6624F · Substantial damage