NTSB investigations: Cessna 150K
8 cases on aircraft the registry lists as Cessna 150K, where the first occurrence was “Loss of engine power”. 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.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1984 | 1 |
| 1988 | 1 |
| 1994 | 1 |
| 2006 | 1 |
| 2007 | 1 |
Where
Open the mapLatest cases
Query with SQL
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071822')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071822')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 DFW08LA018Accident · No injuriesLimited investigationFinal reportCessna 150K · Flora, MSLoss of engine power due to fuel contamination. A contributing factor was the lack of suitable terrain for the forced landing.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.NTSB BFO94LA081Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Hollis, NHThe pilot's inadequate preflight inspection which failed to detect contaminated fuel which resulted in fuel starvation.NTSB LAX88LA262Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Dana Point, CADuring a fish spotting operation over the ocean, the engine began to run rough and vibrate. The engine quit completely shortly thereafter and the airplane was ditched in the ocean. The airplane was not recovered. The plt stated that the eng lost power then…NTSB NYC84LA186Accident · No injuriesLimited investigationFinal reportCessna C150 · Stow, MADuring the initial takeoff climb at about 400 ft AGL the acft experienced a loss of power. During the emergency descent the eng restarted and ran for aprx 30 seconds before quiting again. The plt perofrmed a forced landing into the pine trees below.NTSB ATL84LA060Accident · No injuriesLimited investigationFinal reportCessna 150K · Georgetown, KYEarlier in the day, an annual inspection had been completed. There were no refueling facilities on the arpt, so the plt/mechanic drove to another location & purchased a can of gasoline (6 gals) which he added to the tanks. He then started the eng &…NTSB MKC83LA164Accident · No injuriesLimited investigationFinal reportCessna 150 · Creve Coeur, MOThe student plt had made 2 landings at the arrowhead arpt, then returned to Creve Coeur arpt where he made a full stop landing. He took off again, and reportedly, applied carburetor heat on downwind. As he continued, he applied full flaps for the landing.…NTSB LAX82DA144Accident · No injuriesFinal reportCessna 150K · 9 Sw Santa Barb, CAThe engine lost power while the pilot was spotting fish at night. He was unable to restart the engine or glide back to the shore. The plane was ditched about 3 1/2 miles from the shore and was not recovered.