Skip to content

NTSB investigations: Cessna 150H, IN

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

19682026

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 ('2071818')) 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 ('2071818'))
  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 ('2071818'))
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 CEN10CA045Accident · No injuriesData collectionFinal reportCessna 150H · Paoli, INThe pilot's failure to maintain directional control of the airplane during landing.Nov 7, 2009 · N22896 · Substantial damage 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.Oct 29, 2006 · N23175 · Substantial damage NTSB CHI01LA328Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Lebanon, INThe unsuitable terrain for landing encountered by the pilot. Factors were the carburetor icing conditions, the carburetor ice, and the bean crop.Sep 23, 2001 · N6609S · Substantial damage NTSB CHI00LA311Accident · No injuriesLimited investigationFinal reportCessna 150H · Michigan City, INfuel contamination (water) and the pilot exceeding his landing field distance. Factors relating to this accident were the pilot inadequate preflight planning/preparation, his having to select an unsuitable landing area, the short landing area, and the marsh.Sep 30, 2000 · N50318 · Substantial damage NTSB CHI98LA263Accident · No injuriesLimited investigationFinal reportCessna 150H · Frankfort, INthe improper maintenance installation by other maintenance personnel. Factors were a missing lubricating oil drain plug, the safety wire for the plug and the roadway.Jul 18, 1998 · N22047 · Substantial damage NTSB CHI93LA376Accident · No injuriesLimited investigationFinal reportCessna 150H · Gary, INan improper climb airspeed established by the pilot-in-command after banner pickup.Sep 26, 1993 · N22313 · Substantial damage NTSB CHI90LA068Accident · No injuriesLimited investigationFinal reportCessna 150H · Sullivan, INThe student pilot's inadequate compensation for the wind gust and lack of total experience.Jan 19, 1990 · N50292 · Substantial damage NTSB CHI84LA403Accident · No injuriesLimited investigationFinal reportCessna 150H · Indianapolis, INThe plt stated that during the takeoff roll, the window popped open. At about that time, the acft began traveling to the left side of the rwy, but the plt elected to continue the takeoff. While in a nose high attitude to takeoff, the aft fuselage contacted a…Sep 22, 1984 · N22667 · Substantial damage NTSB CHI81FEX06Accident · Serious injuriesClosedCessna 150H · Kokomo, INDec 7, 1980 · N6475S · Destroyed NTSB CHI78FEX43Accident · Minor injuriesClosedCessna 150H · Monticello, INSep 27, 1978 · N23016 · Destroyed NTSB CHI77FEX24Accident · Minor injuriesClosedCessna 150H · Sheridan, INMay 8, 1977 · N23396 · Substantial damage NTSB CHI76FET47Accident · No injuriesClosedCessna 150H · Gary, INAug 15, 1976 · N50189 · Substantial damage NTSB CHI75FET23Accident · No injuriesClosedCessna 150 · Peru, INJun 27, 1975 · N23020 · Substantial damage NTSB CHI75DEA18Accident · Minor injuriesClosedCessna 150H · Jeffersonville, INApr 16, 1975 · N22374 · Substantial damage NTSB CHI73AC073Accident · 2 fatalClosedCessna 150 · Rockville, INFeb 24, 1973 · N6474S · Destroyed NTSB CHI73AC027Accident · 1 fatalClosedCessna 150H · Grovertown, INAug 25, 1972 · N22402 · Destroyed NTSB CHI72FEA34Accident · No injuriesClosedCessna 150H · Terre Haute, INMar 3, 1972 · N23238 · Substantial damage NTSB CHI72FET14Accident · Minor injuriesClosedCessna 150H · South Bend, INFeb 22, 1972 · N7240S · Destroyed NTSB CHI71DBA24Accident · No injuriesClosedCessna 150H · Richmond, INJan 9, 1971 · N22701 · Substantial damage NTSB CHI71FBA22Accident · No injuriesClosedCessna 150H · Terre Haute, INDec 29, 1970 · N50349 · Substantial damage NTSB CHI70AC079Accident · 2 fatalClosedCessna 150H · Greenwood, INMay 12, 1970 · N7208S · Destroyed NTSB CHI70DBA03Accident · No injuriesClosedCessna 150H · Bloomington, INJan 16, 1970 · N23238 · Substantial damage NTSB CHI69F0667Accident · Serious injuriesClosedCessna 150H · Indian Sprgs, INMay 27, 1969 · N50153 · Destroyed NTSB CHI69F0584Accident · No injuriesClosedCessna 150H · Bloomington, INDec 20, 1968 · N22980 · Substantial damage NTSB CHI69D0295Accident · No injuriesClosedCessna 150 · Muncie, INSep 29, 1968 · N22275 · Substantial damage NTSB CHI69F0247Accident · No injuriesClosedCessna 150 · Bargersville, INSep 15, 1968 · N23197 · Substantial damage NTSB CHI69A0025Accident · 1 fatalClosedCessna 150H · Terre Haute, INAug 28, 1968 · N7239S · Destroyed