NTSB investigations: Cessna 150K, AR

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

19702026

NTSB investigations: Cessna 150K, AR per year, 1970–2026: 8 cases
1970	1
1976	1
1978	1
1979	1
1984	2
1999	1
2013	1

Where

Open the map

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 ('2071822')) 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 ('2071822'))
  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 ('2071822'))
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 CEN13LA342Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Morrilton, ARThe flight instructor's inadequate training and oversight of the student pilot, which resulted in the noncertificated student pilot's loss of control during landing.Jun 10, 2013 · N6412G · Substantial damage NTSB FTW99LA245Accident · No injuriesLimited investigationFinal reportCessna 150K · Springdale, ARThe inadequate visual lookout by both pilots.Aug 23, 1999 · N6015G · 2 aircraft · Substantial damage NTSB MKC84LA125Accident · No injuriesLimited investigationFinal reportCessna 150K · Paragould, ARA student pilot carrying a passenger landed to refuel. Unaware of the procedure to acquire fuel at this location, he took off for another airport. The engine quit on climb-out and the aircraft was substantially damaged when it landed short of the runway. No…Apr 14, 1984 · N6057G · Substantial damage NTSB MKC84LA083Accident · No injuriesLimited investigationFinal reportCessna C-150K · Hot Springs, ARThe acft collided with trees during the forced landing 1/4 mile from the rwy. The plt had landed only 19 miles from the accident, and finding no fuel available at the unattended arpt decided to continue his flt. Just short of destination the acft, ran out of…Feb 25, 1984 · N6063G · Substantial damage NTSB FTW79DPG26Accident · No injuriesClosedCessna 150 · Marked Tree, ARApr 14, 1979 · N6433G · Substantial damage NTSB FTW78FA067Accident · 2 fatalClosedCessna 150K · De Queen, ARAug 13, 1978 · N5969G · Destroyed NTSB FTW76DPG54Accident · No injuriesClosedCessna 150 · Bay, ARMay 18, 1976 · N6049G · Substantial damage NTSB FTW70DPG33Accident · No injuriesClosedCessna 150 · Ravenden Spgs, ARMay 28, 1970 · N5734G · Substantial damage