NTSB investigations: Cessna 150J, AR
13 cases on aircraft the registry lists as Cessna 150J. 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
| 1971 | 2 |
|---|---|
| 1975 | 2 |
| 1976 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 2002 | 1 |
| 2021 | 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.\"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 ('2071820'))
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 ('2071820'))
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 CEN21LA231Accident · No injuriesClass 3 · LimitedFinal reportCessna 150J · Madison, ARThe pilot’s improper fuel planning which led to fuel exhaustion, and a total loss of engine power.NTSB FTW02LA090Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Melbourne, ARthe pilot's failure to maintain directional control as a result of becoming incapacitated due to a stroke while taxiing for takeoff.NTSB MKC90LA095Accident · No injuriesLimited investigationFinal reportCessna 150 · Allport, ARImproper use of carburetor heat by the pilot. Contributing factors were carburetor icing conditions, power lines and visual outlook inadequate by the pilot.NTSB MKC88LA065Accident · No injuriesLimited investigationFinal reportCessna 150J · Searcy, ARWhile landing in direct crosswind, the PIC lost directional control during the roll out. The acft veered off the runway, damaging the right wing tip and empennage. The pilot stated he thought a gust of wind caused the loss of control.NTSB MKC84LA171Accident · No injuriesLimited investigationFinal reportCessna 150J · El Dorado, ARThe acft collided with a ditch while taxiing after landing. The plt was attempting to make a 180 degree turn on the rwy. She said she turned right to allow more room to swing left. She said that she was then unable to depress the left rudderpedal. The acft…NTSB FTW83LA159Accident · No injuriesLimited investigationFinal reportCessna 150J · El Dorado, ARThe acft collided with trees after running off the end of the rwy during an aborted takeoff. The student plt made 2 touch and go landings and taxied in to have his seat fixed. After the repair he taxied out and held for about 5 minutes for traffic. After…NTSB FTW82FPG19Accident · 1 fatalFinal reportCessna 150J · North Little Ro, ARAfter a right turn after takeoff from rwy 17 the plt declared an emergency. A witness heard the eng backfiring. The plt continued the right turn & attempted a landing on rwy 35. He was described as being too high & hot, & touched down, or almost touched down,…NTSB FTW81DPG21Accident · No injuriesClosedCessna 150 · Marshall, ARNTSB FTW76FPG98Accident · Serious injuriesClosedCessna 150J · Batesville, ARNTSB FTW76DPG08Accident · No injuriesClosedCessna 150 · Amity, ARNTSB FTW75FPG84Accident · No injuriesClosedCessna 150J · Arkadelphia, ARNTSB FTW72DPG58Accident · No injuriesClosedCessna 150 · Heth, ARNTSB FTW71FPG46Accident · No injuriesClosedCessna 150J · Monticello, AR