Skip to content

NTSB investigations · 94

Matched to the registry by N-number and event date, newest first.

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('2071824') 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('2071824')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('2071824')
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 ERA21LA291Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A150K · Brooksville, FLA total loss of engine power as a result of carburetor icing.Jul 13, 2021 · N8412M · Substantial damage NTSB CEN12LA388Accident · No injuriesLimited investigationFinal reportCessna A150K · Mamou, LAThe pilot's inadequate preflight inspection, which resulted in a partial loss of engine power due to fuel contamination.Jun 23, 2012 · N8380M · Substantial damage NTSB DFW08FA036Accident · 1 fatalField investigationFinal reportCessna A150K · Mesquite, TXThe flight instructor's failure to maintain sufficient airspeed to avoid a stall during takeoff-initial climb. Factors contributing to the accident are the instructor's decision to takeoff with excessive flaps, the improper maintenance replacement of the flap…Nov 23, 2007 · N8301M · Destroyed NTSB SEA03LA193Accident · No injuriesLimited investigationFinal reportCessna A150K · Medford, ORThe student pilot's failure to maintain directional control of the aircraft during the landing roll.Sep 18, 2003 · N8351M · Substantial damage NTSB MIA01LA073Accident · No injuriesLimited investigationFinal reportCessna A150K · Cabo Rojo, PRThe failure of the pilot to use carburetor heat during descent resulting in loss of engine power due to carburetor icing and the airplane colliding with a fence and nosing over during a forced landing.Feb 6, 2001 · N5915J · Substantial damage NTSB NYC00LA189Accident · No injuriesLimited investigationFinal reportCessna 150 · Freemont, DEThe pilot's failure to maintain altitude/clearance and delayed power application while attempting to release a banner from the airplane.Jul 7, 2000 · N8362M · Substantial damage NTSB FTW00LA092Accident · No injuriesLimited investigationFinal reportCessna 150K · Davis, OKFuel exhaustion due to the student pilot becoming lost/disoriented. A factor was the lack of suitable terrain for the forced landing.Mar 11, 2000 · N8435M · Substantial damage NTSB ATL98FA025Accident · 2 fatalField investigationFinal reportCessna A150K · Jacksonville, FLthe pilot's failure to maintain adequate flying speed following a banner pick up, which resulted in a stall and an uncontrolled collision with the ground. A related factor was: the pilot allowed the maximum certificated gross weight of the airplane to be…Dec 17, 1997 · N1218M · Substantial damage NTSB FTW97LA290Accident · No injuriesLimited investigationFinal reportCessna A150K · Elgin, OKfuel contamination, and the pilot's inadequate preflight of the airplane. Trees in the emergency landing area were considered a related factor.Jul 30, 1997 · N8332M · Substantial damage NTSB FTW94FA138Accident · 2 fatalField investigationFinal reportCessna A150K · Mccrory, ARWas the inadvertent stall and spin. Factors were the pilot's performance of aerobatics at an inadequate altitude.Apr 27, 1994 · N8457M · Destroyed NTSB CHI93FA274Accident · 2 fatalField investigationFinal reportCessna A150K · Goshen, INFailure of both pilots to see and avoid each other. A factor in the accident was the position of the sun which resulted in sun glare for the pilot of the mong sport.Jul 25, 1993 · N8382M · 2 aircraft · Destroyed NTSB MIA92LA177Accident · No injuriesLimited investigationFinal reportCessna A150K · Palatka, FLThe pilot in command's failure to maintain airspeed while performing a go around resulting in the aircraft stalling and descending uncontrolled to the ground.Sep 7, 1992 · N8367M · Substantial damage NTSB ATL91LA010Accident · No injuriesLimited investigationFinal reportCessna A150K · Dublin, GAThe pilot's inadequate preflight planning and preparation, in that he did not ensure that enough fuel was on board to complete the flight.Oct 26, 1990 · N8390M · Substantial damage NTSB ANC90FA146Accident · 2 fatalField investigationFinal reportCessna A150 · Kenai, AKPilot-in-command's failure to maintain control of the airplane.Aug 15, 1990 · N8345M · Destroyed NTSB FTW89FA015Accident · 2 fatalField investigationFinal reportCessna A150K · Flint, TXThe airplane was observed flying on an easterly heading at low altitude, with the propeller stopped. One of the witnesses said the airplane was gliding toward him and when close he started running away. He said the airplane abruptly turned left and went…Nov 6, 1988 · N5913J · Destroyed NTSB CHI88LA023Accident · No injuriesLimited investigationFinal reportCessna A150K · Elkhart, INThe plt of Cessna A150K, N8382M, was landing after the plt of another Cessna 150 had landed & had started to back-taxi up the same rwy. The plt of the other acft stated that she had announced her intentions to back taxi up the rwy & that she did not hear any…Nov 14, 1987 · N8382M · Substantial damage NTSB ANC88LA009Accident · Minor injuriesLimited investigationFinal reportCessna A150K · Whittier, AKThe PIC got lost while flying above an overcast. When he finally found an opening and descended below the clouds he was low on fuel. He located some buildings on a narrow beach and attempted to land. He overshot the beach and struck stacks of building…Oct 16, 1987 · N8477M · Substantial damage NTSB CHI87FA129Accident · 2 fatalField investigationFinal reportCessna A150K · Scotts, MIThe airplane had been circling a residence at tree top level when a witness saw the nose drop and the acft descend steeply toward the terrain. The airplane struck a power line before ground impact.May 16, 1987 · N8331M · Destroyed NTSB MKC87FA048Accident · 1 fatalField investigationFinal reportCessna A150K · West Memphis, ARThe airplane was making low passes over the edge of a trailer park and at the end of each pass, it would climb almost straight up and then make a steep banked turn and dive for another pass. At the end of the last pullup, the airplane made an abrupt steep…Feb 7, 1987 · N8459M · Destroyed NTSB DEN86FA170Accident · 1 fatalField investigationFinal reportCessna A150K · Silver City, NMThe student plt took a private plt for a sight seeing ride. The acft was over gross weight and the density alt was calculated to be 9,292 feet. On an approach to landing the student plt elected to go around. The surviving plt said that in a steep bank the…Jun 21, 1986 · N6DW · Destroyed NTSB LAX86LA139Accident · No injuriesLimited investigationFinal reportCessna A150K · Hanakuli, HIThe acft was ditched in pacific ocean after the eng quit. Recovered inboard portion of left wing showed gas tank cap missing. The ditching occurred 1 mile from shore and the occupants were picked up unharmed after 20 minutes in the water. The plt said the eng…Mar 13, 1986 · N8467M · Destroyed NTSB NYC86LA054Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Marlboro, NJThe acft encountered what the plt described as a strong gust of wind on landing. The plt stated he experienced a wind shift of aprx 45 degs. The acft touched down fast and during subsequent bouncing the nose gear collapsed. The winds, according to the plt,…Dec 28, 1985 · N5915J · Substantial damage NTSB LAX85LA377Accident · No injuriesLimited investigationFinal reportCessna A150K · Avalon, CAThe plt said the operation was about 4 and 1/2 hours into a commercial fish spotting flt when the engine 'began to run rough, then quit altogether.' Attempts to restart the engine were unsuccessful and the plt completed a power-off ditching at sea. He and the…Aug 31, 1985 · N8409M · Destroyed NTSB LAX84LA295Accident · No injuriesLimited investigationFinal reportCessna A150K · Trona, CAThe acft settled back to the rwy and veered of the left side during takeoff. The plt stated that he attempt a short field takeoff and the acft would not accelerate to more than 60 mph. It settled onto the dirt off the left side of the rwy and groundlooped to…May 12, 1984 · N8376M · Substantial damage NTSB LAX84LA243Accident · No injuriesLimited investigationFinal reportCessna A150K · Chico, CAWhen the acft was about 7 mi from its destination, the eng lost power & the plt elected to land on an access road. During the landing roll, the left wing hit the top of a fence & the acft veered left. The nosewheel then struck a curb & the acft nosed over.…Apr 6, 1984 · N8334M · Substantial damage NTSB SEA84LA024Accident · No injuriesLimited investigationFinal reportCessna A150K Aerobat · Nr. Wrangell, AKThe acft nosed over during landing on a snow covered sand bar. The weather was VMC. The plt said he underestimated the depth of the snow and upon landing the nose gear collapsed and the acft nosed over.Nov 25, 1983 · N8403M · Substantial damage NTSB CHI84LA001Accident · No injuriesLimited investigationFinal reportCessna 150 · Iron River, MIThe plt reported that the eng lost power during flt due to carburetor ice. He applied carburetor heat, but the eng would not restart. During a forced landing, the acft encounter rough/uneven terrain & subsequently nosed over.Oct 1, 1983 · N8340M · Substantial damage NTSB LAX83LA355Accident · 1 fatalLimited investigationFinal reportCessna A150K · Stonyford, CAThe acft collided with the ground while negotiating a low level aerobatic maneuver. The acft had departed a private ranch airstrip and according to a witness the acft was 'rolled'. After a few circles of the strip. The witness was surprised because the plt…Jul 23, 1983 · N8353M · Destroyed NTSB LAX83LA307Accident · Serious injuriesLimited investigationFinal reportCessna A150K · San Diego, CAWitnesses observed the acft circling over the housing development at low altitude. The acft banked steeply, pitched up & the nose fell through the horizon. The student plt flying the acft resided four houses away from where the acft crashed.Jun 25, 1983 · N8496M · Destroyed NTSB LAX83LA239Accident · No injuriesLimited investigationFinal reportCessna 150K · Tucson, AZThe acft became misaligned with the runway during landing and landed in a crab which collapsed the nose gear and the left main gear. The pilot stated that he got caught in a dust-devil which blew him sideways. According to the operator who witnessed the…May 20, 1983 · N8406M · Substantial damage NTSB ATL82DA124Accident · No injuriesFinal reportCessna A150 · Leonardtown, MDThe pilot reported that his speed was fast on base leg and final approach. After touchdown he bounced back into the air and added power for a go-around, however, he failed to return the carburetor heat control to the cold position and the aircraft did not…Apr 29, 1982 · N5919J · Substantial damage NTSB NYC82FHM02Accident · No injuriesClosedCessna 150 · Mahopac, NYNov 26, 1981 · N8368M · 2 aircraft · Destroyed NTSB FTW81FPJ19Accident · Serious injuriesClosedCessna A150K · Norman, OKApr 15, 1981 · N8382M · Substantial damage NTSB MIA80DLD64Accident · No injuriesClosedCessna 150 · Plant City, FLMay 3, 1980 · N8412M · Substantial damage NTSB IAD79FGN43Accident · No injuriesClosedCessna A150K · Herron, WVAug 13, 1979 · N8448M · Substantial damage NTSB NYC79FHJ12Accident · Minor injuriesClosedCessna 150 · Selden, NYMay 19, 1979 · N8478M · Substantial damage NTSB OAK79DVA13Accident · No injuriesClosedCessna A150K · Merced, CAJan 18, 1979 · N5909J · Substantial damage NTSB SEA79FA017Accident · 1 fatalClosedCessna 150K · Astoria, ORDec 10, 1978 · N8339M · Destroyed NTSB LAX78DUM36Accident · Minor injuriesClosedCessna A150K · Imperial, CASep 12, 1978 · N8348M · Destroyed NTSB CHI78DEC23Accident · No injuriesClosedCessna 150 · Caseville, MIMar 19, 1978 · N8395M · Substantial damage NTSB NYC78FGT03Accident · No injuriesClosedCessna 150K · Bloomsburg, PAFeb 11, 1978 · N5915J · Substantial damage NTSB NYC78FHJ06Accident · Minor injuriesClosedCessna 150 · Islip, NYFeb 8, 1978 · N5918J · Substantial damage NTSB FTW77FRD38Accident · No injuriesClosedCessna 150K · Gillis, LAJul 8, 1977 · N8382M · Substantial damage NTSB OAK77FVA29Accident · No injuriesClosedCessna A150K · Fresno, CAApr 24, 1977 · N8399M · Substantial damage NTSB OAK76FVM25Accident · No injuriesClosedCessna 150 · San Jose, CAMar 7, 1976 · N8373M · Substantial damage NTSB OAK76AP039Accident · 1 fatalClosedCessna A150K · Oakland, CADec 29, 1975 · N8430M · Destroyed NTSB OAK76FVG33Accident · No injuriesClosedCessna A150K · Lincoln, CANov 12, 1975 · N8417M · Substantial damage NTSB MIA75DLA44Accident · Serious injuriesClosedCessna 150K · Pittman, FLMay 18, 1975 · N8413M · Substantial damage NTSB CHI75FEM40Accident · No injuriesClosedCessna 150K · Battle Creek, MIMay 11, 1975 · N8452M · Substantial damage NTSB CHI75FEK14Accident · No injuriesClosedCessna A150K · Marion, OHOct 8, 1974 · N8383M · Substantial damage

Back to Cessna A150K