Skip to content

NTSB investigations: Cessna 150G, IN

23 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

19662026

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" = 'IN' 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\" = 'IN' 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" = 'IN' 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 CHI06CA170Accident · No injuriesData collectionFinal reportCessna 150G · Indianapolis, INThe pilot intentionally leaving the airplane unoccupied during the engine start and the failure of the tail tie-down, which ultimately resulted in the unoccupied airplane becoming airborne.Jun 27, 2006 · N3366J · Substantial damage 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.Sep 20, 2000 · N4770X · Destroyed NTSB CHI98LA158Accident · No injuriesLimited investigationFinal reportCessna 150 · Griffith, INThe aircraft's speed not maintained by the pilot, which resulted in the aircraft stalling in close proximity to the ground.May 21, 1998 · N2916J · Substantial damage NTSB CHI97LA168Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Franklin, INthe instructor pilot stalled the aircraft as a result of inadequate preflight planning. Factors included the transmission wire, the rising terrain, and the trees at the departure end of the runway.Jun 17, 1997 · N3787J · Destroyed NTSB CHI88LA246Accident · No injuriesLimited investigationFinal reportCessna 150G · Butler, INDuring a solo flight, the student pilot attempted a landing on a neighbor's cow pasture. The student stated that he misjudged the approach to landing and landed long on the field. He was unable to adequately handle the aircraft and failed to get it stopped…Sep 24, 1988 · N8570J · Substantial damage NTSB CHI88FA144Accident · 1 fatalField investigationFinal reportCessna 150G · Ft Wayne, INInadvertent stall/spin due to the failure to maintain adequate airspeed, and failure to avoid the adverse wind conditions associated with a thunderstorm.Jun 28, 1988 · N4744X · Destroyed NTSB CHI84LA256Accident · No injuriesLimited investigationFinal reportCessna 150G · Spindle, INThe pilot stated that he ran out of useable fuel while in cruise flt. The pilot executed an emergency landing in a newly mowed hayfield and the acft sustained substantial damage. The pilot stated that he should have 'gotten fuel at lafayette.'Jun 22, 1984 · N4772X · Substantial damage NTSB CHI82FA012Accident · 1 fatalClosedCessna 150 · Palmyra, INNov 14, 1981 · N4732X · Destroyed NTSB CHI80FA062Accident · 1 fatalClosedCessna 150 · Mishawaka, INAug 8, 1980 · N3118J · Destroyed NTSB CHI77FEX06Accident · 1 fatalClosedCessna 150G · Patriot, INDec 15, 1976 · N2879S · Destroyed NTSB CHI74DEA18Accident · Minor injuriesClosedCessna 150 · Brazil, INOct 27, 1973 · N4027J · Substantial damage NTSB CHI73ACO48Accident · No injuriesClosedCessna 310A · Lafayette, INNov 16, 1972 · N347P · 2 aircraft · Substantial damage NTSB CHI73FEA17Accident · No injuriesClosedCessna 150G · Jeffersonvile, INSep 19, 1972 · N4070J · Substantial damage NTSB CHI71AC076Accident · 1 fatalClosedCessna 150 · Knox, INApr 12, 1971 · N4682X · Destroyed NTSB CHI71DBA16Accident · No injuriesClosedCessna 150 · Bloomfield, INOct 24, 1970 · N6220S · Substantial damage NTSB CHI71DBA14Accident · No injuriesClosedCessna 150 · Anderson, INSep 29, 1970 · N2932J · Substantial damage NTSB CHI70D0365Accident · No injuriesClosedCessna 150G · Logansport, INNov 7, 1969 · N3879J · Substantial damage NTSB CHI70F0192Accident · Serious injuriesClosedCessna 150 · Plymouth, INJun 28, 1969 · N3451J · Destroyed NTSB CHI69D0434Accident · No injuriesClosedCessna 150 · Marion, INJan 8, 1969 · N3879J · Substantial damage NTSB CHI69D0211Accident · No injuriesClosedCessna 150 · Richmond, INAug 17, 1968 · N2744S · Substantial damage NTSB CHI69F0060Accident · Serious injuriesClosedCessna 150G · Knox, INJul 5, 1968 · N3254J · Substantial damage NTSB CHI68D0372Accident · No injuriesClosedCessna 150 · Indianapolis, INOct 23, 1967 · N3764J · Substantial damage NTSB CHI67F0294Accident · No injuriesClosedCessna 150 · Lewis, INNov 12, 1966 · N3769J · Substantial damage