NTSB investigations: Cessna 150H
13 cases on aircraft the registry lists as Cessna 150H, where the first occurrence was “In flight collision with object”. 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 | 2 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1995 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2006 | 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 ('2071818')
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\" = 220))
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 ('2071818')
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" = 220))
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 CHI07LA010Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Monroe City, INThe student pilot not maintaining clearance from the tree during climb. Factors were the tree and the student pilot's lack of total experience.NTSB ATL01LA052Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Maryville, TNThe pilot's inadequate preflight planning that resulted in the in-flight collision with a fence during an attempted takeoff from a grass strip.NTSB NYC00LA224Accident · Minor injuriesLimited investigationFinal reportCessna 150 · East Moriches, NYThe pilot's failure to maintain a climb during climbout. A factor in the accident was the pilot's failure to reconfigure the flaps for the aborted landing.NTSB IAD99LA054Accident · No injuriesLimited investigationFinal reportCessna 150 · Granville, NYThe pilot's not maintaining a proper glidepath during the visual approach to the runway.NTSB LAX96LA048Accident · 1 fatalLimited investigationFinal reportCessna 150H · Imperial, CAthe student pilot's misreading of the altimeter while in the traffic pattern, which put the aircraft in dangerous proximity to the ground and obstructions. A factor in the accident was the pilot's inability to see the power pole due to sun glare as the…NTSB ATL95LA085Accident · No injuriesLimited investigationFinal reportCessna 150H · Bath, NCA bird, which collided with and fractured the aircraft windshield, resulting in an emergency landing. A factor was the soft terrain at the emergency landing site.NTSB FTW93LA091Accident · No injuriesLimited investigationFinal reportCessna 150H · Adkins, TXThe student pilot's failure to maintain clearance while maneuvering. A factor was the student's diverted attention from the open engine inspection doorNTSB FTW92LA222Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Mcgehee, ARThe pilot's failure to maintain clearance.NTSB MIA88FA071Accident · 1 fatalField investigationFinal reportCessna 150H · Destin, FLWitnesses stated that they observed the acft flying in the fog in a southeasterly direction and turn hard right just before it struck the 19th floor of a condominium. The fog according to residents of the bldg was so thick that the ground could not be seen…NTSB LAX85LA273Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Waipahu, HIAprx 1/2 hr into this dual instructional flt the acft struck unmarked high voltage pwr cables, entered an uncontrolled descent and struck the ground. One of the purposes of the flt was to practice emergency apch procedures. Both the instructor and the student…NTSB NYC85LA004Accident · No injuriesLimited investigationFinal reportCessna 150H · Batavia, NYPlt stated en route time was longer than anticipated. On arrival at destination, deep dusk conditions combined with haze, restricted ground reference cues. In addition, plt stated he misread the altimeter. Acft collided with trees 1 mile short of runway. Plt…NTSB NYC82DA113Accident · No injuriesFinal reportCessna 150H · Cross Keys, NJAccording to the pilot, the aircraft touched down during landing, about halfway down the runway, then bounced several times. He elected to go around, applied full power, and moved the flap handle to the up position. The flaps were fully extended and did not…NTSB SEA82FA064Accident · 2 fatalField investigationFinal reportCessna 150H · Oregon City, ORThe aircraft crashed during takeoff from a private airport that was not open to the public. Operations on the airport were at the owner's discretion (prior permission required). An electric fence crossed the airport about 1500 ft from the south end. The owner…