Skip to content

NTSB investigations: Cessna 150K, FL

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

19702026

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" = 'FL' 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 ('2071822')) 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\" = 'FL' 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 ('2071822'))
  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" = 'FL' 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 ('2071822'))
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 ERA24LA347Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Gainesville, FLThe separation of a nose landing gear axle retaining nut and the subsequent the failure of the nose landing gear during landing.Aug 16, 2024 · N6495G · Substantial damage NTSB MIA07LA028Accident · No injuriesLimited investigationFinal reportCessna 150K · Cape Coral, FLThe pilot's in-flight encounter with carburetor ice and inadequate remedial action which resulted in the engine ceasing to operate and a forced landing and damage to the airplane during the landing.Dec 17, 2006 · N6069G · Substantial damage NTSB MIA03CA041Accident · Serious injuriesData collectionFinal reportCessna 150K · Everglades City, FLThe instructor's failure to maintain airspeed during climb after lift off from an aborted landing, resulting in the airplane stalling, entering a spin, and crashing into water at the departure end of the runway. Contributing to the accident was the…Jan 11, 2003 · N5629G · Substantial damage NTSB MIA97LA054Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Daytona Beach, FLthe pilot's improper planning/decision, by failing to ensure there was sufficient fuel for continued flight, which resulted in fuel exhaustion and subsequent collision with objects (concrete blocks) during a forced landing. Factors relating to the accident…Jan 1, 1997 · N5813G · Substantial damage NTSB MIA89LA197Accident · No injuriesLimited investigationFinal reportCessna 150 · Deland, FLImproper flare by the pilot and his improper recovery from a bounced landing.Jul 12, 1989 · N5814G · Substantial damage NTSB MIA87LA044Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Apollo Beach, FLWhile in cruise flt at 600 feet a sudden loss of engine power occurred. Attempts to restart the engine were unsuccessful and the aircraft was ditched. Post accident examination of the engine revealed no evidence of mechanical failure or malfunction. The icing…Dec 6, 1986 · N6330G · Substantial damage NTSB MIA83LA162Accident · No injuriesLimited investigationFinal reportCessna 150K · Boynton Bch., FLThe acft was involved in a hard landing, collapsing the nose gear, followed by a nose over. The pilot stated he added power which made the nose collapse a little slower. The acft nosed over about 400 feet from touchdown.Jun 5, 1983 · N5917G · Substantial damage NTSB MIA83FA058Accident · 2 fatalField investigationFinal reportCessna 150 · Green Cove Spgs, FLThe acft crashed in a spin after the engine quit during takeoff. This was one of a series of touch and go landings. The acft reached an alt of about 150 ft when the engine sputtered and quit. The acft then started a 180 degree turn which steepened into a spin…Jan 8, 1983 · N6503G · Destroyed NTSB MIA82DA143Accident · Minor injuriesFinal reportCessna 150 · Hollywood, FLWhile on final approach for landing, the pilot noticed a loss of power at about 500 ft AGL. He verified that his carburetor heat was on and pushed the throttle forward. Power was restored for a second, but once again, it was lost. While landing on hospital…Jun 27, 1982 · N6064G · Destroyed NTSB MIA80DKT02Accident · Serious injuriesClosedCessna 150 · South Bay, FLOct 7, 1979 · N6077G · Substantial damage NTSB MIA76DKT66Accident · No injuriesClosedCessna 150 · Key Largo, FLMar 29, 1976 · N5971G · Substantial damage NTSB MIA75DLG37Accident · No injuriesClosedCessna 150 · Opa Locka, FLApr 27, 1975 · N5890G · Substantial damage NTSB MIA75DKT58Accident · No injuriesClosedCessna 150 · Miami, FLJan 13, 1975 · N5640G · Substantial damage NTSB MIA75DLD51Accident · No injuriesClosedCessna 150K · Plymouth, FLJan 4, 1975 · N6069G · Destroyed NTSB MIA75DKT26Accident · No injuriesClosedCessna 188 · Indiantown, FLNov 8, 1974 · N5751G · Substantial damage NTSB MIA75DKT08Accident · No injuriesClosedCessna 150 · West Palm Bch, FLSep 13, 1974 · N6123G · Substantial damage NTSB MIA74DLD98Accident · No injuriesClosedCessna 150K · Merritt Isl, FLJun 13, 1974 · N5814G · Substantial damage NTSB MIA74AM064Accident · 1 fatalClosedCessna 150K · Stuart, FLFeb 1, 1974 · N6256G · Destroyed NTSB MIA74DKT53Accident · No injuriesClosedCessna 150 · Cooper City, FLJan 25, 1974 · N5971G · Substantial damage NTSB MIA74DKT26Accident · No injuriesClosedCessna 150K · Opa Locka, FLOct 13, 1973 · N6244G · Substantial damage NTSB MIA74AM029Accident · 2 fatalClosedCessna 150K · Melbourne, FLOct 9, 1973 · N5904G · Destroyed NTSB MIA74AM025Accident · 1 fatalClosedCessna 150K · Melbourne, FLSep 22, 1973 · N6086G · Destroyed NTSB MIA73DKT79Accident · Minor injuriesClosedCessna 150 · Opa Locka, FLApr 5, 1973 · N6038G · Substantial damage NTSB MIA73DLA28Accident · No injuriesClosedCessna 150 · High Springs, FLFeb 21, 1973 · N5814G · Substantial damage NTSB MIA73FLD18Accident · No injuriesClosedCessna 150K · Tampa, FLOct 6, 1972 · N6310G · Substantial damage NTSB MIA73DKT16Accident · No injuriesClosedCessna 150K · Andytown, FLSep 17, 1972 · N5674G · Substantial damage NTSB MIA72DKT34Accident · No injuriesClosedCessna 150 · W Palm Beach, FLDec 7, 1971 · N6031G · Substantial damage NTSB MIA72AM046Accident · No injuriesClosedCessna 150K · Opa Locka, FLNov 18, 1971 · N5922G · 2 aircraft · Substantial damage NTSB MIA72FLA15Accident · No injuriesClosedCessna 150 · Pensacola, FLOct 16, 1971 · N5873G · Substantial damage NTSB MIA71FLA47Accident · No injuriesClosedCessna 150K · Crestview, FLMay 21, 1971 · N6386G · Substantial damage NTSB MIA71FLA14Accident · No injuriesClosedCessna 150K · Milton, FLOct 8, 1970 · N5856G · Substantial damage NTSB MIA71FLD19Accident · Minor injuriesClosedCessna 150 · Vero Beach, FLSep 20, 1970 · N5972G · Destroyed NTSB MIA71AM011Accident · 2 fatalClosedCessna 150K · Miami Beach, FLAug 1, 1970 · N6428G · Destroyed NTSB MIA70FLA20Accident · Serious injuriesClosedCessna 150K · Jacksonville, FLApr 25, 1970 · N5920G · Substantial damage