Skip to content

NTSB investigations: Cessna 150L, MD

20 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

19722026

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" = 'MD' 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\" = 'MD' 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" = 'MD' 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 ERA13CA383Accident · No injuriesData collectionFinal reportCessna 150L · Chestertown, MDThe student pilot's improper control inputs which resulted in a loss of control and aerodynamic stall. Contributing to the accident was the flight instructor's delayed remedial action.Aug 27, 2013 · N1574Q · Substantial damage NTSB NYC05CA062Accident · No injuriesData collectionFinal reportCessna 150L · Mitchellville, MDThe pilot's inadequate compensation for wind conditions. A factor was the gusty wind conditions.Mar 19, 2005 · N11965 · Substantial damage NTSB IAD01LA083Accident · No injuriesLimited investigationFinal reportCessna 150L · Lusby, MDThe student pilot's improper use of carburetor heat.Jul 23, 2001 · N21964 · Substantial damage NTSB IAD99LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Clinton, MDThe student pilot's improper flare and improper recovery from a bounced landing.Oct 11, 1998 · N11951 · Destroyed NTSB IAD98LA098Accident · No injuriesLimited investigationFinal reportCessna 150L · Cumberland, MDThe pilot in command's improper recovery from a bounced landing.Aug 22, 1998 · N7513G · Substantial damage NTSB NYC97LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Clarksville, MDThe pilot's failure to maintain directional control and failure to abort the takeoff.Feb 20, 1997 · N11438 · Substantial damage NTSB BFO94LA077Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Westminster, MDThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall and the inflight loss of control. A factor is the pilot's failure to do a go around.Apr 25, 1994 · N11522 · Destroyed NTSB BFO89LA076Accident · No injuriesLimited investigationFinal reportCessna 150 · Gaithersburg, MDAn undetermined problem with the ignition system. A factor related to the accident was: the pilot's failure to properly secure the airplane or obtain proper assistance.Aug 26, 1989 · N6840G · Substantial damage NTSB BFO87LA014Accident · No injuriesLimited investigationFinal reportCessna 150L · Ellicott City, MDApproximately 30 minutes after the pilot departed hayes field, columbia, Maryland, the pilot elected to return to the field. After entering downwind the engine ceased to continue producing power and the pilot was forced to make an emergency landing. During…Jan 13, 1987 · N18140 · Substantial damage NTSB BFO86FA029Accident · Minor injuriesField investigationFinal reportCessna 150L · Upper Marlboro, MDThe acft made a forced landing after the eng began to overheat during cruise flt about 20 minutes after departure. The plt stated that as soon as he smelled the oil heating up he knew what the problem was. He had not removed the foam plugs from the air…May 30, 1986 · N11463 · Substantial damage NTSB ATL82FA072Accident · 1 fatalField investigationFinal reportCessna 150 · Tilghman Island, MDThe student pilot/owner of the aircraft was endorsed to fly the plane and would fly it from his farm on Tilghman Island to easton, MD for dual instruction. Several days before the accident, he had asked his instructor (ip) to schedule some time for an early…Mar 17, 1982 · N10914 · Destroyed NTSB ATL81FIA02Accident · No injuriesClosedCessna 150 · Newburg, MDFeb 7, 1981 · N18668 · 2 aircraft · Substantial damage NTSB ATL80FIA09Accident · No injuriesClosedCessna 150 · Clinton, MDMay 27, 1980 · N5368Q · Substantial damage NTSB IAD79FA086Accident · Minor injuriesClosedCessna 150 · Gaithersburg, MDSep 20, 1979 · N11593 · Substantial damage NTSB IAD79DA071Accident · No injuriesClosedCessna 150 · Oakland, MDAug 20, 1979 · N5344Q · Destroyed NTSB IAD77FIG34Accident · No injuriesClosedCessna 150L · Tryaskin, MDAug 21, 1977 · N10765 · Substantial damage NTSB IAD74FIG25Accident · Minor injuriesClosedCessna 150 · White Marsh, MDApr 26, 1974 · N6755G · Substantial damage NTSB IAD74FIG16Accident · Serious injuriesClosedCessna 150 · Laurel, MDDec 4, 1973 · N19327 · Substantial damage NTSB NYC72FIG27Accident · Minor injuriesClosedCessna 150 · Gaithersburg, MDJun 25, 1972 · N5439Q · Substantial damage NTSB NYC72AN115Accident · 1 fatalClosedCessna 150L · Stevensville, MDMar 18, 1972 · N1670Q · Destroyed