Skip to content

NTSB investigations: Cessna 150G, AR

19 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" = 'AR' 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\" = 'AR' 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" = 'AR' 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 CEN19FA332Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Prairie Grove, ARThe noninstrument-rated pilot's loss of control due to spatial disorientation after encountering instrument meteorological conditions at night.Sep 24, 2019 · N4658X · Substantial damage NTSB CEN11LA188Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Springdale, ARThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Feb 12, 2011 · N3257J · Substantial damage NTSB FTW03LA109Accident · No injuriesLimited investigationFinal reportCessna 150G · Hope, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Mar 15, 2003 · N493RA · Substantial damage NTSB FTW94LA027Accident · No injuriesLimited investigationFinal reportCessna 150G · Salem, ARPartial loss of engine power for undetermined reasons. A factor was unsuitable terrain for the forced landing.Nov 7, 1993 · N2225J · Substantial damage NTSB FTW91LA159Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Benton, ARA loss of engine power for unknown reasons.Aug 28, 1991 · N8482J · Substantial damage NTSB MKC86LA042Accident · No injuriesLimited investigationFinal reportCessna 150 · Carlisle, ARThe student plt was making the takeoff, after a stop and go landing. The acft began to drift to the lt during the roll and the CFI cautioned the student to correct for torque. The CFI took control but was unable to get the student to release the controls…Dec 31, 1985 · N4649X · Substantial damage NTSB FTW84LA008Accident · No injuriesLimited investigationFinal reportCessna 150G · Forrest City, ARDuring a landing, the acft touched down hard, then bounced & touched down hard, 2 more times. On the 3rd impact, the nose gear collapsed. Subsequently, the acft slid to a stop with damage to the propeller & firewall.Oct 2, 1983 · N2938S · Substantial damage NTSB FTW78DPG10Accident · No injuriesClosedCessna 150 · Newark, ARDec 9, 1977 · N560MA · Substantial damage NTSB FTW78FRJ09Accident · Serious injuriesClosedCessna 150G · Texarkana, ARNov 27, 1977 · N3240X · Destroyed NTSB FTW77DPG44Accident · No injuriesClosedCessna 150G · Arkadelphia, ARJun 11, 1977 · N6256S · Substantial damage NTSB FTW77DPG14Accident · No injuriesClosedCessna 150 · El Dorado, ARDec 23, 1976 · N8430J · Substantial damage NTSB FTW73AF035Accident · 2 fatalClosedCessna 150G · Manila, ARJan 1, 1973 · N3802J · Destroyed NTSB FTW72AF050Accident · 2 fatalClosedCessna 150G · Bono, ARFeb 10, 1972 · N6350S · Destroyed NTSB FTW72DPG37Accident · Minor injuriesClosedCessna 150G · Abbott, ARSep 5, 1971 · N6296S · Substantial damage NTSB FTW71AF048Accident · No injuriesClosedCessna 150H · W.Memphis, ARFeb 17, 1971 · N23323 · 2 aircraft · Substantial damage NTSB FTW70A0034Accident · 1 fatalClosedCessna 150 · Lake Village, ARNov 22, 1969 · N6375S · Destroyed NTSB FTW69F0336Accident · Minor injuriesClosedCessna 150 · Wynne, ARNov 28, 1968 · N3603J · Substantial damage NTSB FTW69F0163Accident · No injuriesClosedCessna 150 · Hattieville, ARSep 3, 1968 · N4040J · Destroyed NTSB FTW68F0142Accident · No injuriesClosedCessna 150 · Walnut Ridge, ARJul 26, 1967 · N3857J · Substantial damage