Final NTSB investigations: Cessna 150L, ND

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19732026

Final NTSB investigations: Cessna 150L, ND per year, 1973–2026: 11 cases
1973	3
1975	1
1986	1
1988	1
1990	2
1991	1
2006	1
2016	1

Where

Open the map

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" = 'ND' AND c."eventCountry" = 'USA' AND c."completionStatus" = 'Completed' 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

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\" = 'ND' AND c.\"eventCountry\" = 'USA'
    AND c.\"completionStatus\" = 'Completed'
    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."eventStateOrRegion" = 'ND' AND c."eventCountry" = 'USA'
  AND c."completionStatus" = 'Completed'
  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

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 CEN16LA350Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Upham, NDThe pilot's failure to obtain a proper aimpoint during landing due to reduced visibility from the setting sun.Aug 31, 2016 · N18601 · Substantial damage NTSB CHI06CA229Accident · No injuriesData collectionFinal reportCessna 150 · Jamestown, NDThe pilot's inadequate preflight planning resulted in the pilot not attaining the proper takeoff climb and failure to maintain terrain clearance. Contributing factors included the transmission wires, the row of trees, and the field of corn.Aug 12, 2006 · N17015 · Substantial damage NTSB CHI91LA075Accident · No injuriesLimited investigationFinal reportCessna 150 · Rolla, NDCompensation for wind was inadequate anad directional control not maintain by the PIC. Contributing factors were: snow covered runway, gusty crosswind, and a snowbank.Jan 18, 1991 · N18583 · Substantial damage NTSB CHI90FA214Accident · 2 fatalField investigationFinal reportCessna 150L · Donnybrook, NDThe pilot's failure to maintain airspeed while maneuvering in hilly terrain. Contributing factors were the pilot's failure to maintain adequate altitude and the surrounding steeply rising terrain.Aug 5, 1990 · N10094 · Destroyed NTSB DEN90FA161Accident · 2 fatalField investigationFinal reportCessna 150L · Hettinger, NDThe pilot's failure to maintain airspeed during climbout. Contributing factors were: the pilot's lack of recent experience, and the over maximum gross weight condition of the aircraft.Jul 13, 1990 · N11580 · Destroyed NTSB DEN88LA060Accident · No injuriesLimited investigationFinal reportCessna 150L · Reynolds, NDFeb 1, 1988 · N11312 · Substantial damage NTSB DEN86LA084Accident · No injuriesLimited investigationFinal reportCessna 150L · Watford City, NDThe acft made a hard landing on rwy 30 at Watford City muni arpt, ND, and was substantially damaged. The student plt said the accident occurred on the third touch-and-go. The plt said he used only 10 degrees of flaps. He noted some turbulence and an increase…Feb 27, 1986 · N16210 · Substantial damage NTSB MKC7KAK062Accident · 1 fatalClosedCessna 150L · Minot, NDJun 16, 1975 · N1508Q · Destroyed NTSB MKC74DTG08Accident · No injuriesClosedCessna 150 · Fargo, NDOct 16, 1973 · N1728Q · Substantial damage NTSB MKC74DTG01Accident · No injuriesClosedCessna 150 · Tuttle, NDJul 3, 1973 · N1743Q · Substantial damage NTSB MKC73AK062Accident · 2 fatalClosedCessna 150L · Medinan, NDApr 16, 1973 · N5243Q · Destroyed