Skip to content

NTSB investigations: Cessna 150G, MO

30 cases on aircraft the registry lists as Cessna 150G. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19672026

Where

Latest cases

Query with SQL

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."eventStateOrRegion" = 'MO' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071816')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"eventStateOrRegion\" = 'MO' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071816'))
  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."eventStateOrRegion" = 'MO' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071816'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN16LA004Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Dexter, MOThe pilot's impairment due to the ingestion of alcohol, which impaired his decision-making and resulted in his taking off and flying the airplane until the engine lost power due to fuel exhaustion.Oct 5, 2015 · N3174J · Substantial damage NTSB CHI05LA217Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Mountain View, MOThe loss of engine power for undetermined reasons during climb after takeoff.Aug 9, 2005 · N4080J · Substantial damage NTSB CHI95LA156Accident · No injuriesLimited investigationFinal reportCessna 150G · Stockton, MOthe pilot's inadequate compensation for the crosswind weather condition and subsequent failure to maintain directional control. Factors were the crosswind and the ditch.May 20, 1995 · N4774X · Substantial damage NTSB CHI95LA136Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Springfield, MOThe student pilot's failure to refuel the airplane. The student pilot's inadequate fuel consumption calculations were a related factor.Apr 26, 1995 · N3112J · Substantial damage NTSB CHI94LA035Accident · No injuriesLimited investigationFinal reportCessna 150G · Neosho, MOThe pilot-in-command's failure to maintain directional control during landing rollout.Nov 9, 1993 · N2263J · Substantial damage NTSB CHI94LA005Accident · No injuriesLimited investigationFinal reportCessna 150G · Osceola, MOFracture of the number four piston at the piston pin boss. A factor related to the accident was: the lack of suitable terrain for an emergency landing.Oct 3, 1993 · N4646X · Substantial damage NTSB CHI90LA246Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Reeds Spring, MOA delayed go-around.Aug 28, 1990 · N2973S · Destroyed NTSB MKC90LA072Accident · No injuriesLimited investigationFinal reportCessna 150 · Concordia, MOInadequate pre-flight planning and preparation, misjudged fuel consumption calculations and re-fueling not performed by the pilot in command.Mar 22, 1990 · N3650J · Substantial damage NTSB MKC85LA198Accident · No injuriesLimited investigationFinal reportCessna 150G · Camdenton, MOThe pilot and son were on a personal cross-country flight when the engine quit. The airplane nosed forward to the inverted position during the landing roll. The reason for the engine failure could not be determined.Aug 30, 1985 · N3240J · Substantial damage NTSB MKC81DCG52Accident · No injuriesClosedCessna 150 · Lees Summit, MOJul 26, 1981 · N7691C · Substantial damage NTSB MKC81DCG13Accident · Serious injuriesClosedCessna 150G · Columbia, MONov 7, 1980 · N3799J · Substantial damage NTSB MKC80FA037Accident · Serious injuriesClosedCessna 150G · Dekalb, MOMay 28, 1980 · N3920J · Destroyed NTSB MKC78DCG43Accident · No injuriesClosedCessna 150 · Green Castle, MOJul 1, 1978 · N4011J · Substantial damage NTSB MKC78DCG09Accident · No injuriesClosedCessna 150 · Nevada, MONov 24, 1977 · N3708J · Substantial damage NTSB MKC75FCA34Accident · Serious injuriesClosedCessna 150 · Poplar Bluff, MOJun 30, 1975 · N3501L · Substantial damage NTSB MKC74DCD24Accident · No injuriesClosedCessna 150 · Matthews, MOMar 8, 1974 · N3133X · Substantial damage NTSB MKC72DCA06Accident · No injuriesClosedCessna 150C · Poplar Bluff, MOAug 25, 1971 · N8434J · Substantial damage NTSB MKC71FCG56Accident · Serious injuriesClosedCessna 150G · Albany, MOApr 12, 1971 · N8315J · Destroyed NTSB MKC70DCA07Accident · No injuriesClosedCessna 150 · Willow Springs, MOApr 7, 1970 · N2208J · Substantial damage NTSB MKC70DCG19Accident · No injuriesClosedCessna 150 · Green City, MOApr 3, 1970 · N3675J · Substantial damage NTSB MKC70D0187Accident · Minor injuriesClosedCessna 150 · Independence, MOAug 2, 1969 · N3181J · Substantial damage NTSB MKC70F0069Accident · Serious injuriesClosedCessna 150 · Grain Valley, MOMay 1, 1969 · N2281J · Destroyed NTSB MKC68A0059Accident · 1 fatalClosedCessna 150 · Kansas City, MOApr 10, 1968 · N6386S · 2 aircraft · Substantial damage NTSB MKC68D0520Accident · No injuriesClosedCessna 150 · Camdenton, MOApr 7, 1968 · N3838J · Substantial damage NTSB MKC68F0481Accident · Minor injuriesClosedCessna 150 · Ferrelview, MOFeb 18, 1968 · N8545J · Destroyed NTSB MKC68D0378Accident · No injuriesClosedCessna 150 · Creve Coeur, MODec 6, 1967 · N3457J · Substantial damage NTSB MKC68F0271Accident · No injuriesClosedCessna 150 · Orchard Farm, MOJun 13, 1967 · N3637J · Substantial damage NTSB MKC68D0240Accident · No injuriesClosedCessna 150G · Portge D Sioux, MOJun 8, 1967 · N2635J · Substantial damage NTSB MKC68D0144Accident · No injuriesClosedCessna 150 · Malden, MOMay 5, 1967 · N4647X · Destroyed NTSB MKC67F0514Accident · No injuriesClosedCessna 150 · Plattsburg, MOMay 2, 1967 · N8323J · Substantial damage