Skip to content

NTSB investigations: Cessna 150L, VA

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

19732026

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" = 'VA' 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 ('2071826')) 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\" = 'VA' 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 ('2071826'))
  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" = 'VA' 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 ('2071826'))
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 GAA16CA396Accident · Minor injuriesData collectionFinal reportCessna 150 · Williamsburg, VAAn evasive maneuver during the landing flare to avoid deer on the runway, which resulted in a collision with trees and terrain during a go-around. Contributing to the accident was the lack of an airport perimeter fence.Jul 27, 2016 · N18228 · Substantial damage NTSB NYC03LA122Accident · No injuriesLimited investigationFinal reportCessna 150 · Culpeper, VAThe pilot's failure to maintain directional control on the runway during takeoff.Jun 8, 2003 · N92WA · Substantial damage NTSB NYC01LA091Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Wintergreen, VAThe pilot's improper decision to continue the flight into deteriorating weather.Mar 31, 2001 · N5433Q · Substantial damage NTSB NYC99LA054Accident · No injuriesLimited investigationFinal reportCessna 150 · Burnt Chimney, VAThe pilot's decision to land on a short runway with a strong tailwind, and his failure to obtain a proper touchdown point.Feb 6, 1999 · N19186 · Destroyed NTSB BFO92LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Lynchburg, VAThe pilot's poor in-flight decision making resulting in fuel exhaustion. Contributing to the accident was the pilot's overall lack of experience.Mar 12, 1992 · N5258Q · Substantial damage NTSB BFO92LA006Accident · No injuriesLimited investigationFinal reportCessna 150L · Portsmouth, VACollisiion with the deer on the runway. A factor was the dark night.Nov 15, 1991 · N19595 · Substantial damage NTSB BFO91LA026Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Harrisonburg, VAThe pilot's failure to maintain directional control. Contributing to the accident was premature raising of the flaps, and inadequate airspeed.Feb 3, 1991 · N19240 · Destroyed NTSB BFO87LA055Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Danville, VAThe accident occurred during an instructional x-country flt from chesapeake, VA. To south boston, VA. To ashland, VA. With a return to chesapeake. Prior to departure, the student plt performed the acft preflt and informed the CFI that the acft was topped off.…Aug 17, 1987 · N11872 · Substantial damage NTSB ATL81FIA10Accident · Minor injuriesClosedCessna 150 · Luray, VASep 19, 1981 · N18736 · Destroyed NTSB ATL81DID09Accident · Minor injuriesClosedCessna 150 · Woolwine, VADec 24, 1980 · N6559G · Substantial damage NTSB ATL81DID07Accident · Serious injuriesClosedCessna 150L · Ruckersville, VADec 22, 1980 · N1240Q · Substantial damage NTSB IAD79DID18Accident · No injuriesClosedCessna 150L · Lexington, VAMay 30, 1979 · N21961 · Substantial damage NTSB IAD78DIJ06Accident · No injuriesClosedCessna 150 · Abingdon, VADec 2, 1977 · N7735G · Substantial damage NTSB IAD78DID01Accident · Serious injuriesClosedCessna 150L · Wintergreen, VAOct 8, 1977 · N2602Q · Destroyed NTSB IAD76FID04Accident · No injuriesClosedCessna 150L · Waynesboro, VAAug 10, 1975 · N1486Q · Substantial damage NTSB IAD75AI066Accident · Serious injuriesClosedCessna 150L · Manassas, VAJun 28, 1975 · N1308Q · 2 aircraft · Destroyed NTSB IAD75F2A08Accident · No injuriesClosedCessna 150 · Fulks Run, VAOct 25, 1974 · N10102 · Substantial damage NTSB IAD75FIG06Accident · Serious injuriesClosedCessna 150L · Sterling, VAOct 9, 1974 · N10093 · Substantial damage NTSB IAD74FID42Accident · No injuriesClosedCessna 150L · Ashland, VAJun 30, 1974 · N10574 · Substantial damage NTSB IAD74AI041Accident · 1 fatalClosedCessna 150L · Samos, VAFeb 4, 1974 · N6927G · Destroyed NTSB NYC73FIA10Accident · No injuriesClosedCessna 150L · Manassas, VAFeb 12, 1973 · N1308Q · Substantial damage