NTSB investigations: Cessna 150J
15 cases on aircraft the registry lists as Cessna 150J, 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 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1987 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 1999 | 2 |
| 2005 | 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 ('2071820')
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 ('2071820')
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 LAX05FA062Accident · 1 fatalField investigationFinal reportCessna 150J · Marana, AZthe failure of the pilot to maintain an adequate altitude and clearance from obstructions that resulted in an in-flight collision with power lines.NTSB LAX99LA187Accident · No injuriesLimited investigationFinal reportCessna 150J · Alderpoint, CAThe pilot's inadequate compensation for the existing turbulent, gusty wind conditions during the approach. Contributing factors were the pilot's delayed go-around maneuver, the gusty and turbulent winds, and the tree.NTSB ATL99LA079Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Seneca, SCThe pilot's failure to maintain adequate airspeed which resulted in a stall and subsequent impact with trees.NTSB NYC93LA162Accident · No injuriesLimited investigationFinal reportCessna 150 · Mcgaheysville, VAThe flight instructor's inadequate supervision resulting in a delayed go-around.NTSB CHI92LA276Accident · No injuriesLimited investigationFinal reportCessna 150J · Marlette, MIThe pilot-in-command's (CFI) inadequate supervision of the dual student pilot and the dual student's inadvertent application of the brakes.NTSB LAX92LA095Accident · No injuriesLimited investigationFinal reportCessna 150J · Pinyon, CAThe flight instructor's inadequate in-flight planning to enter a mountainous area at a low altitude, and his improper handling of the airplane. Factors which contributed to the accident related to the instructor's lowering of the wing flaps during a time when…NTSB ATL91FA110Accident · 1 fatalField investigationFinal reportCessna 150J · Monroe, GAThe pilots attempted flight in adverse weather and the physical impairment of the student pilot from the consumption of alcoholic beverages prior to flight. A factor in the accident was the foggy weather condition at the airport.NTSB MIA90LA179Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Geneva, FLThe pilots failure to retract the flaps to the takeoff setting during a touch-and-go landing.NTSB ATL89LA192Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Dunn, NCThe pilot's failure to properly calculate the takeoff distance required for the conditions and the airplane collided with power lines during climbout.NTSB NYC87LA248Accident · No injuriesLimited investigationFinal reportCessna 150J · Brookline, NHDuring an approach to land at night, the pilot saw deer on the runway that were facing his direction and moving to the right. He didn't see the deer until he had reached a point were a go-around would be unsafe for this runway. In an effort to avoid the deer,…NTSB FTW87LA150Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Chelsea, OKThe non-rated plt attempted a downwind takeoff from a 1450' pvt grass strip. The strip was soft from recent rain & contained grass & weeds which were 6 to 7 inches hi. After taking off, the acft would not climb fast enough to clear obstacles. Subsequently, it…NTSB CHI84LA363Accident · No injuriesLimited investigationFinal reportCessna 150 · Brookville, OHThe CFI made a successful forced landing on a highway median strip while on a dual night x-country flt after a pwr loss occurred. CFI drained the fuel sumps and was able to restart the engine. He then decided to takeoff from the median and fly the acft back…NTSB SEA83FA062Accident · 1 fatalField investigationFinal reportCessna 150J · Glenns Ferry, IDThe acft collided with wires and crashed during a low pass while it was being delivered to a repair station. The pilot was flying low to keep pace with his wife who was following in a car to transport the pilot after landing. Witnesses observed the acft…NTSB FTW82DA339Accident · Minor injuriesFinal reportNorth American AT-6A · Abilene, TXThe pilot landed on runway after the T-6 landed on grass to right of the runway. The T-6 turned toward the ramp and crossed path of the Cessna on the runway. A collision occurred as the Cessna pilot tried to go-around and overfly the AT-6.NTSB FTW82DA186Accident · No injuriesFinal reportCessna 150 · Knowles, OKDuring a cross country flight the student pilot elected to land in a pasture near his home. On takeoff the aircraft collided with a fence resulting in substantial damage to the aircraft. The pilot returned to the pasture and landed without further incident.…