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_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 ('1151202')
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 ('1151202')
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 DEN90LA141Accident · No injuriesLimited investigationFinal reportBeech 23 · Wheatland, WYPermature liftoff.NTSB NYC90LA035Accident · No injuriesLimited investigationFinal reportBeech B-23 · Tinton Falls, NJPrecautionary landing in unsuitable terrain following a partial power loss due to a failed exhaust valve.NTSB ATL89LA221Accident · Minor injuriesLimited investigationFinal reportBeech B23 · Hatteras, NCLoss of engine power for an unknown reason.NTSB LAX89LA195Accident · No injuriesLimited investigationFinal reportBeech 23 · Glendale, AZThe pilot's failure to execute a go around in a timely manner. The delay in aborting the landing precluded the airplane from accelerating to a climb airspeed before colliding with a fence.NTSB LAX89LA026Accident · No injuriesLimited investigationFinal reportBeech 23 · San Carlos, CADuring a telephone interview the pilot stated that he landed too FAR down runway 12. He said that when he considered going around, he was already committed to complete the landing. Winds at the time of the accident were reported to be from 360 degrees at 5…NTSB ATL88IA242Incident · No injuriesIncident investigationFinal reportBeech 23 · Frankfort, KYEngine quit during go-around from simulated engine failure. During completion of emergency procedure the fuel selector position was changed to opposite wing fuel tank. Later exam of the acft revealed that when the fuel selector valve handle indicated right…NTSB DEN88LA182Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Pueblo, CONTSB MKC88LA095Accident · No injuriesLimited investigationFinal reportBeech 23 · Independence, MOThe PIC planned a local flt to practice touch and go lndgs. On an earlier flt the PIC had switched the fuel selector to what he thought was the fullest tank. As the subsequent flt progressed, the PIC again selected what he considered to be the fullest tank as…NTSB CHI88DEC01Accident · Minor injuriesFinal reportBeech 23 · Brighton, MIThe unsuitable terrain (trees and a lake) encountered during a forced landing made necessary by the partial failure of the aircraft's powerplant during and attempted go-around. The occupants were able to exit the aircraft before it sank; the aircraft was…NTSB NYC88LA111Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Rutland, VTPrior to leaving the aircraft to hand prop the engine, the pilot checked the throttle setting and set the brakes. He told his passenger (his wife) to pull back on the throttle when the engine started, however she was unable to do so and the aircraft began…NTSB BFO88LA004Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Front Royal, VAWhile flying at abt 2000 ft AGL, the plt noticed a change in eng sound. The tach indcn dropped below 1000 RPM & the suction gauge went below the green arc. During a subsequent emerg lndg, the nose & left main gear collapsed in soft terrain. No preimpact part…NTSB SEA87LA195Accident · No injuriesLimited investigationFinal reportBeech 23 · Basin City, WAThe pilot was making a low pass over the ground for a possible off airport landing next to his farm. During the low approach, he noticed power lines ahead and pushed forward on the controls to clear under them. However, there was a wrecked vehicle below the…NTSB MIA87FA250Accident · 3 fatalField investigationFinal reportBeech 23 · St. Petersburg, FLThe pilot of the commonwealth erroneously reported his positon to the tower for landing instructions. He then failed to follow the instructions and collided with a Beech 23 acft that was on downwind to land at albert whitted airport. Both aircraft involved in…NTSB MIA87FA189Accident · 2 fatalField investigationFinal reportBeech 23 · Miramar, FLAfter the plt lndd, the acft was serviced with 58.9 gal of fuel. Its fuel capacity was 60 gal. Subsequently, when the plt took off, the acft remained on the rwy for about 2500' of the available 3000'. After lift-off, the acft entered a rgt turn & reached a…NTSB ATL87LA078Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Augusta, GAThe acft was flown from a pvt strip to a nrby arpt at statesboro, GA for refueling. After the acft was refueled, the englost pwr as the student plt was taxiing to takeoff. Water was fnd in the sumps, & rprtdly, 4 to 6 samples were required to drain water from…NTSB CHI87LA028Accident · No injuriesLimited investigationFinal reportBeech 23 · Laporte, INThe plt stated that at the initial full throttle position the acft developed 2450 RPM. According to the plt, at approximately 200 feet of altitude he noticed a loss of rpm's to 2050 and he immediately rechecked the throttle and mixture controls, the magneto…NTSB LAX85LA335Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Kamuela, HIOn July 31, 1985, a Beech BE-23 operated by a student pilot, crashed during an attempted go-around at the waimea-kohala airport in Hawaii. The acft sustained substantial damage and the plt received minor injuries. The plt indicated he had not used full flaps…NTSB ATL84LA123Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Rome, GAThe acft lost power in the traffic pattern and forced landed off the arpt. The weather was conducive to carburetor icing. The plt said he applied carburetor heat after reducing power.NTSB FTW83LA153Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Athens, LAJust prior to the flt, a mechanic performed some minor upkeep functions on the acft & knew of no mechanical problems. He was unaware that the owner was not a rated plt. The mechanic accompanied the owner on a local flt. Subsequently, the acft crashed on the…NTSB CHI82DA075Accident · No injuriesFinal reportBeech 23 · Aitkin, MNAfter landing on a partially snow covered runway the pilot lost directional control and struck a snowbank. The aircraft traveled approximately 15 feet before nosing down into the snow covered terrain.NTSB DEN81FTI20Accident · Serious injuriesClosedBeech 23 · Deer Lodge, MTNTSB SEA81DYM41Accident · No injuriesClosedBeech B23 · Orchards, WANTSB NYC81FGM25Accident · Minor injuriesClosedBeech 23 · Irwin, PANTSB DEN81FTE58Accident · No injuriesClosedBeech 23 · Eaton, CONTSB NYC81FFA18Accident · Serious injuriesClosedBeech 23 · Livingston Mnr, NYNTSB CHI81DER08Accident · No injuriesClosedBeech 23 · Alexandria, MNNTSB ATL80DKQ20Accident · Minor injuriesClosedBeech 23 · Collins, MSNTSB CHI80FER45Accident · No injuriesClosedBeech 23 · Deerpark, WINTSB SEA80FYP19Accident · No injuriesClosedBeech 23 · Quincy, WANTSB FTW79DPJ39Accident · Minor injuriesClosedBeech 23 · Waukomis, OKNTSB IAD79FKW02Accident · Serious injuriesClosedBeech A23 · Knoxville, TNNTSB CHI78FEV52Accident · No injuriesClosedBeech 23 · Minonk, ILNTSB FTW78DRD39Accident · No injuriesClosedBeech 23 · Grand Terre, LANTSB IAD78DKM05Accident · No injuriesClosedBeech B23 · Sophia, NCNTSB NYC77FGM41Accident · No injuriesClosedBeech 23 · Finleyville, PANTSB FTW77FRJ08Accident · No injuriesClosedBeech 23 · Edom, TXNTSB NYC77FHA19Accident · Minor injuriesClosedBeech 23 · Sterling, PANTSB MKC77FCG20Accident · No injuriesClosedBeech M23 · Lees Summit, MONTSB CHI77FA036Accident · 2 fatalClosedBeech 23 · Morris, ILNTSB SEA76DYE53Accident · No injuriesClosedBeech 23 · Blakely Island, WANTSB FTW76FPM23Accident · No injuriesClosedBeech 23 · Leonard, OKNTSB CHI76DEE33Accident · No injuriesClosedBeech 23 · Dekalb, ILNTSB FTW76FPG24Accident · No injuriesClosedBeech 23 · Hazen, ARNTSB MKC76DER10Accident · No injuriesClosedBeech A23 · Pine City, MNNTSB MKC76FER05Accident · No injuriesClosedBeech 23 · Alexandria, MNNTSB IAD75AI064Accident · 1 fatalClosedBeech 23 · Kenly, NCNTSB MKC75FCA32Accident · No injuriesClosedBeech 23 · Chesterfield, MONTSB NYC75FNC25Accident · No injuriesClosedBeech 23 · Manchester, NHNTSB MIA75DLD54Accident · No injuriesClosedBeech 23 · Winter Haven, FLNTSB MKC75FTG11Accident · Minor injuriesClosedBeech 23 · Minot, ND
Back to Beech 23