NTSB investigations: Cessna 150F
17 cases on aircraft the registry lists as Cessna 150F, 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
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 4 |
| 1989 | 1 |
| 1992 | 1 |
| 1996 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2002 | 2 |
| 2003 | 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 ('2071814')
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 ('2071814')
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 ATL03LA048Accident · No injuriesLimited investigationFinal reportCessna 150F · Rome, GAThe maintenance personnel failure to secure the throttle linkage during the installation of the carburetor that resulted in the loss of engine power.NTSB FTW02LA248Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Deming, NMThe loss of engine power due to carburetor ice as a result of the pilot's failure to apply carburetor heat. A contributing factor was the weather conducive to carburetor icing conditions.NTSB CHI02LA190Accident · No injuriesLimited investigationFinal reportCessna 150F · Ft. Wayne, INThe corroded throttle cable resulting in a loss of engine power. Factors were the inadequate annual inspection, the unsuitable terrain encountered during the forced landing, the ditch, and the fence.NTSB FTW00LA248Accident · No injuriesLimited investigationFinal reportCessna 150F · Guthrie, OKThe partial loss of engine power due to undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB LAX00LA081Accident · No injuriesLimited investigationFinal reportCessna 150F · Windsor, CAThe pilot's inadequate preflight planning in that he did not perform a fuel calculation, and his failure to verify the fuel quantity on board the airplane, which resulted in fuel exhaustion and subsequent collision with the ground.NTSB ANC99LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Fairbanks, AKThe loss of engine power for an undetermined reason.NTSB MIA96LA214Accident · No injuriesLimited investigationFinal reportCessna 150F · Plant City, FLa loss of engine power due to fuel contamination, resulting in a forced landing, and subsequent nose over. A factor in this accident was an inadequate aircraft pre-flightNTSB FTW93LA004Accident · No injuriesLimited investigationFinal reportCessna 150F · Hughes, ARThe loss of control during the landing roll. A factor was the partial loss of engine power.NTSB MKC89LA076Accident · No injuriesLimited investigationFinal reportCessna 150 · Monroe City, MOFuel contamination and the pilot's failure to comply with a maintenance AD. Contributing to the accident was the pilot's operation of the airplane with a known deficiency.NTSB DEN88LA198Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Peyton, CONTSB FTW88LA126Accident · No injuriesLimited investigationFinal reportCessna 150F · Temple, TXAfter the descent, the pilot applied power and the engine started running rough. The pilot was able to get the engine running at full power within several minutes but it quit completely approximately 3 to 4 miles from the airport. The airplane was landed in…NTSB MKC88LA115Accident · No injuriesLimited investigationFinal reportCessna 150 · Trousdale, KSDuring a cross country personal flight, the PIC noticed an excessively high oil temperature. He said he enriched the fuel mixture, and when that failed to cool the engine, he reversed his course back to his departure apt. Shortly after his reversal of course,…NTSB NYC88LA144Accident · No injuriesLimited investigationFinal reportCessna 150F · West Chester, PAThe pilot preflighted the aircraft and performed a runup before takeoff. The flight departed from runway 27. When the aircraft reached about 200 feet, the engine experienced a power loss and altitude could not be maintained. The pilot elected to land in a…NTSB NYC88LA025Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Millbrook, NYThe aircraft had just become airborne when power fluctuation occurred. On the second power loss, carburetor heat was applied but the engine lost power completely. The instructor pilot was making a turn back towards the airport when the wing contacted trees…NTSB LAX86LA272Accident · No injuriesLimited investigationFinal reportCessna 150 · Hesperia, CAThe student pilot and passenger departed carble airport (ccb), upland, CA, on a visual flight rules personal flight to bullhead city, Arizona. The student plt reported while approaching Hesperia, CA at about 7,500 ft m.s.l. the engine began to experience an…NTSB FTW86LPJ04Accident · No injuriesFinal reportCessna 150F · Tulsa, OKThe acft nosed over during a forced landing following a loss of pwr. The plt stated 'quite abit' of water was drained from the fuel system during preflight. Aprx 10 to 15 minutes after takeoff the eng began to sputter and eventually quit. The nose wheel…NTSB FTW84LA177Accident · No injuriesLimited investigationFinal reportCessna 150F · Pearland, TXDuring takeoff, the engine lost power at about 150 feet AGL while the aircraft was climbing. The pilot made an emergency landing in a field 1/2 mile from the airport. The engine was later test run and no malfunctons noted that would account for the power loss.