NTSB investigations: Cessna 150G, NC
27 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.
Cases per year
| 1968 | 3 |
|---|---|
| 1969 | 2 |
| 1970 | 4 |
| 1972 | 1 |
| 1975 | 3 |
| 1978 | 2 |
| 1979 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 2 |
| 1993 | 1 |
| 1997 | 1 |
| 2003 | 1 |
| 2023 | 1 |
Where
Latest 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\" = 'NC' 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" = 'NC' 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" 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 ERA23LA348Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150 · Pink Hill, NCThe pilot’s inadequate compensation for prevailing wind conditions during the landing approach, which resulted in the airplane contacting the ground short of the runway.NTSB ATL04LA026Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Kinston, NCThe pilot's failure to maintain aircraft control which resulted in the dragging of the right wing tip and the on ground collision with a roadway.NTSB MIA97LA143Accident · No injuriesLimited investigationFinal reportCessna 150G · Raleigh, NCfailure of the pilot to maintain proper runway alignment during the attempted landing and go-around. Factors relating to the accident were: the gusty crosswind condition, and proximity of trees to the runway.NTSB ATL93LA085Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Arden, NCThe loss of engine power, and the pilot's premature flare during landing, which resulted in a landing stall. Factors were the high obstructions (trees) trees near the landing site, and the uphill terrain conditionsNTSB ATL88LA064Accident · No injuriesLimited investigationFinal reportCessna 150G · Grantham, NCThe airplane touched down initially on the nose wheel, and the nose landing gear collapsed. The airplane subsequently nosed over. The student plt reportedly had about 2 hrs total PIC (solo) flt time.NTSB ATL87LA259Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Concord, NCWhile on climbout, the stu plt switched radios to the dest UNICOM freq. Unable to contact anyone on that freq, the departure arpt freq was reselected. No contact was established on this freq so the stu plt attempted to rtrn to the arpt. The haze was very…NTSB ATL86LA241Accident · No injuriesLimited investigationFinal reportCessna 150 · Smithfield, NCThe pilot reported that during a practice landing he flared too high off the runway surface. The pilot lowered the nose, causing the nosewheel to strike the runway. The pilot lost control and the acft skidded off the left side, down an embankment and flipped…NTSB ATL86FMG05Accident · No injuriesFinal reportCessna 150 · Yadkinville, NCThe acft was landed improperly and after bouncing two of three times the nose gear separated. The acft then nosed over and suffered further damage to the prop, wings and tail.NTSB ATL85LA119Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Tarboro, NCThe plt was attempting a simulated emergency landing on an ag airstrip & collided with several unmarked power lines while on final approach. The student plt was not authorized to land at the ag strip according to his flight instructor.NTSB ATL83FA224Accident · Serious injuriesField investigationFinal reportCessna 172 · Mocksville, NCN5722T, a Cessna 172, and N3452J, a Cessna 150, collided over the approach end of runway 09 while both acft were on short final approach. Both acft impacted the runway and came to rest about 280 ft east of runway 09 threshold.NTSB ATL82DA270Accident · No injuriesFinal reportCessna 150 · Goldsboro, NCThe aircraft was flown by an unauthorized person after it had been secured for the night and the flight operation had been closed. On the next morning, the plane was found about 200 yards from the departure end of runway 04, where it had crashed. An…NTSB IAD80FLJ04Accident · No injuriesClosedCessna 150G · Knightdale, NCNTSB IAD79FLJ03Accident · Serious injuriesClosedCessna 150 · Hubert, NCNTSB IAD78DKM10Accident · No injuriesClosedCessna 150 · Salisbury, NCNTSB IAD75DLJ29Accident · No injuriesClosedCessna 150 · Princeton, NCNTSB IAD75DKM29Accident · Minor injuriesClosedCessna 150 · Marion, NCNTSB IAD75DKM25Accident · No injuriesClosedCessna 150G · Wadesboro, NCNTSB NYC72FLJ25Accident · No injuriesClosedCessna 150 · Louisburg, NCNTSB IAD71DKM08Accident · No injuriesClosedCessna 150G · Greensboro, NCNTSB IAD71DKM04Accident · No injuriesClosedCessna 150G · Yadkinville, NCNTSB IAD71FLJ07Accident · No injuriesClosedCessna 150G · White Lake, NCNTSB IAD70DKM03Accident · Minor injuriesClosedCessna 150G · Greensboro, NCNTSB IAD70D0063Accident · No injuriesClosedCessna 150G · Advance, NCNTSB IAD70A0017Accident · 1 fatalClosedCessna 150G · Gastonia, NCNTSB DIA69D0051Accident · Minor injuriesClosedCessna 150 · Bryson City, NCNTSB DIA68D0201Accident · Minor injuriesClosedCessna 150 · Tyner, NCNTSB DIA68A0043Accident · 1 fatalClosedCessna 150 · Trinity, NC