NTSB investigations: Cessna 150E
8 cases on aircraft the registry lists as Cessna 150E, 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
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2004 | 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 ('2071812')
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 ('2071812')
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 FTW04CA122Accident · No injuriesData collectionFinal reportCessna 150E · Goldthwaite, TXThe pilot's inadequate in-flight planning and decision not to refuel, which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the dark night conditions.NTSB LAX01LA040Accident · No injuriesLimited investigationFinal reportCessna 150E · Marana, AZThe partial loss of engine power during cruise flight due to an improper maintenance adjustment to the float valve retractor clip of the carburetor. Factors were the lack of suitable terrain for a forced landing and high vegetation.NTSB ATL98LA124Accident · No injuriesLimited investigationFinal reportCessna 150E · Bradenton, FLThe loss of engine power for undetermined reasons.NTSB MIA97LA225Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Columbia, SCThe improper rebuild/remanufacture of the fuel line (obstructed at both ends) that runs between the carburetor and sediment bowl by an unknown person. This resulted in a loss of engine power due to fuel starvation, forced landing to non-suitable terrain, and…NTSB ATL87LA261Accident · Serious injuriesLimited investigationFinal reportCessna 150E · Winston Salem, NCThe stu plt discussed a cross country flt with his CFI, but did not get a sign off nor give a date for the flt. He then rented an acft and departed on the flt. During the flt, the com radio's became inop. The operator and the CFI were called from an enroute…NTSB CHI86FEM11Accident · Serious injuriesFinal reportCessna 150E · Muskegon, MIThe plt rprtd that drg takeoff, the acft lifted off at about the midpoint of the rwy & climbed to just above treetop level. He turned the acft slightly into the wind, then noted that it seem to lose the ability to climb further. The stall warning horn sounded…NTSB NYC84LA169Accident · No injuriesLimited investigationFinal reportCessna C150 · So.Bethlehem, NYThe student pilot and instructor had just started the inital climb when the engine quit at about 100 ft. the application of carburator heat caused a few second burst of power then the engine stopped again. The CFI took the controls and turned left. He landed…NTSB SEA83LA155Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Issaquah, WADuring takeoff on a glider towing operation, the eng lost power at aprx 200 to 250 ft AGL. The glider plt disengaged from the tow plane & the tow plt commenced a power off descent to land on a road. There was conflicting traffic on the road. At about the same…