Skip to content

NTSB investigations: Cessna 150L, NE

16 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

19712026

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" = 'NE' 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 ('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\" = 'NE' 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 ('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" = 'NE' 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 ('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 CEN19LA186Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Omaha, NEThe loss of engine power due to fuel starvation.Jun 28, 2019 · N5256Q · Substantial damage NTSB MKC87LA126Accident · No injuriesLimited investigationFinal reportCessna 150L · Antioch, NEThe rwy was 1900 feet long with 5500 ft density altitude. With pilot and passenger and 30 degrees of flaps and calm wind, airplane lifted off, cleared fence and road. Pilot said he lowered the nose and raised flaps to 20 degrees but may have retracted them…Jun 21, 1987 · N1363Q · Substantial damage NTSB MKC86FA098Accident · 1 fatalField investigationFinal reportCessna 150 · Harrisburg, NEThe acft impacted in a 40 degree nose down attitude following a stall-spin. No mechanical descrepancies were noted with the acft and no pre-existing physical incapacitating history of the PIC was discovered. On two separate occasions prior to this flt, the…Apr 30, 1986 · N10768 · Substantial damage NTSB MKC83LA195Accident · No injuriesLimited investigationFinal reportCessna 150L · S. Sioux City, NEThe plt reported that during a touch-and-go landing on rwy 14 with a southerly wind at 8 KTS, he touched down about 1/4 of the way down the rwy with 20 deg of flaps. The temp was 93 deg & the density altitude was aprx 3800 ft. the plt did not raise the flaps…Aug 17, 1983 · N1911F · Substantial damage NTSB MKC83LA071Accident · No injuriesLimited investigationFinal reportCessna 150L · S. Sioux City, NEThe aircraft drifted left during landing and collided with a snow bank. The instructor stated that the inexperienced student pilot flared the aircraft too high. The aircraft contacted the runway near the centerline but strayed left stillin a nose high…Feb 7, 1983 · N1911F · Substantial damage NTSB MKC82DA063Accident · No injuriesFinal reportCessna 150 · Potter, NEThe student pilot was on his first flight to the "bar j lazy v" ranch. He saw a group of buildings which he believed to be on the ranch. Nearby was a field that appeared to have been bladed to remove grass clumps. He proceeded to make a full flap landing on…Apr 24, 1982 · N1556Q · Substantial damage NTSB MKC82DA050Accident · No injuriesFinal reportCessna 150L · Omaha, NEDuring a maximum angle climb after lift-off, the aircraft stalled while climbing through about 200 to 300 ft AGL. The pilot stated that he lowered the nose to obtain a faster airspeed. However, he believed that the plane descended into diminishing headwinds…Mar 25, 1982 · N21932 · Substantial damage NTSB MKC80FCJ25Accident · No injuriesClosedCessna 150L · Sutton, NEJul 27, 1980 · N17262 · Destroyed NTSB MKC79DCD17Accident · No injuriesClosedCessna 150 · Omaha, NEApr 22, 1979 · N17033 · Substantial damage NTSB MKC77DCJ07Accident · No injuriesClosedCessna 150 · Omaha, NEDec 29, 1976 · N16210 · Substantial damage NTSB MKC75DCJ34Accident · No injuriesClosedCessna 150L · Plattsmouth, NEOct 16, 1974 · N10893 · Substantial damage NTSB MKC74DCJ36Accident · No injuriesClosedCessna 150L · North Platte, NEApr 14, 1974 · N6943G · Substantial damage NTSB MKC74DCJ20Accident · No injuriesClosedCessna 150 · Angora, NEDec 10, 1973 · N11183 · Substantial damage NTSB MKC73FCJ33Accident · No injuriesClosedCessna 150L · Fort Calhoun, NEApr 4, 1973 · N16098 · Substantial damage NTSB MKC72DCJ04Accident · No injuriesClosedCessna 150 · Omaha, NEJul 8, 1971 · N6943G · Substantial damage NTSB MKC71FCJ49Accident · No injuriesClosedCessna 150L · Miller, NEMar 2, 1971 · N6610G · Substantial damage