NTSB investigations: Cessna 150G
15 cases on aircraft the registry lists as Cessna 150G, where the first occurrence was “In flight collision with terrain/water”. 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 | 5 |
|---|---|
| 1986 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 1995 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 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 ('2071816')
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\" = 230))
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 ('2071816')
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" = 230))
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 LAX01LA124Accident · No injuriesLimited investigationFinal reportCessna 150G · San Diego, CAThe student pilot's poor inflight planning/judgement to continue a flight into IFR conditions and not divert to an airport operating under VFR conditions. Factors were the pilot's misunderstanding of his flight limitations, special VFR, and not obtaining a…NTSB CHI00FA302Accident · 2 fatalField investigationFinal reportCessna 150G · Jasper, INthe inadvertent stall by the pilot in command. Contributing factors were the approach airspeed not obtained/maintained by the pilot in command and the wind gusts.NTSB LAX99FA160Accident · 1 fatalField investigationFinal reportCessna 150G · Gorman, CAThe pilot's intentional flight into adverse weather conditions beneath a low ceiling in mountainous terrain.NTSB SEA96LA015Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Douglas, WAThe pilot fell asleep.NTSB BFO93LA098Accident · 1 fatalLimited investigationFinal reportCessna 150 · Milroy, PAThe pilot's inadvertent flight into instrument meteorological conditions, and his failure to maintain clearance with terrain. Factors related to the accident include mountain obscuration and fog.NTSB ANC92LA130Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Black River, AKThe pilot's improper in flight planning/decision, and his failure to maintain a proper altitude to clear the terrain. Contributing to the accident were the pilot's lack of familiarity with the geographic area, and his lack of total experience in the type…NTSB ATL92LA099Accident · 1 fatalLimited investigationFinal reportCessna 150G · Samburg, TNThe pilot's poor judgement in that he attempted aerobatic maneuvers at an altitude that was too low to recover from the maneuver.NTSB CHI90LA107Accident · No injuriesLimited investigationFinal reportCessna 150G · Franklin, WIInadequate compensation for wind conditions by the pilot, and his failure to maintain runway alignment during the attempted go-around (aborted landing). The wind conditions and soft terrain were related factors.NTSB ANC89LA113Accident · No injuriesLimited investigationFinal reportCessna 150 · Duffys Tavern, AKThe selection of the soft sandy strip for takeoff by the pilot and his premature liftoff combined to make it impossible to attain climb airspeed before colliding with bushes at the end of the runway.NTSB FTW86FA054Accident · 1 fatalField investigationFinal reportCessna 150G · Salina, OKA night shift worker was returning home in the early morning hours. Crossing the grand river dam near salinas ok. He saw a flash or glint of metal and a large splash near the middle of the widest part of the lake. Examination of the wreckage indicated that…NTSB ATL82DA270Accident · No injuriesFinal reportCessna 150 · Goldsboro, NCThe aircraft was flown by an unauthorized person after it had been secured for the night and the flight operation had been closed. On the next morning, the plane was found about 200 yards from the departure end of runway 04, where it had crashed. An…NTSB LAX82DUJ41Accident · No injuriesFinal reportCessna 150G · Pima, AZDuring arrival, the pilot entered traffic to land on runway 36. He reported that the wind was from 97 degrees at 10 gusting 15 knots. While landing, he felt the touchdown would be too FAR from the approach end, so he initiated a go-around. The density…NTSB CHI82DA182Accident · No injuriesFinal reportCessna 150G · White Cloud, MIThe student pilot stated he was too high on final approach so he attempted a go-around. As he applied power, the nose increased in pitch attitude and the empennage struck the runway. The aircraft started to turn to the left, the left wing struck the runway…NTSB NYC82FA041Accident · Serious injuriesField investigationFinal reportCessna 150G · Erwinna, PAThis was the student's first solo in powered aircraft. He held a private pilot certificate with a glider rating. His takeoff and traffic pattern appeared normal until the last part of his final approach for landing. About 600 ft short of the runway, the…NTSB FTW82FRD08Accident · 2 fatalFinal reportCessna 150G · Jeanerette, LAAccording to a friend of the deceased pilot and his female companion the three of them had been at a nightclub until 0215 CST. The friend then followed them to the airport, since he lived adjacent to the airport. After arriving he heard an aircraft takoeff.…