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 ('1151010')
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 ('1151010')
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 ANC17LA017Accident · Minor injuriesLimited investigationFinal reportBeech G18 · Metlakatla, AKAn engine power loss for reasons that could not be determined because the airplane was not recovered.NTSB CEN12FA534Accident · 1 fatalField investigationFinal reportBeech G18 - S · Taylorville, ILThe pilot's failure to maintain adequate airspeed and use the appropriate flaps setting during sport-parachuting operations, which resulted in an aerodynamic stall/spin and a subsequent loss of control. Contributing to the accident was the pilot’s failure to…NTSB ANC09CA066Accident · No injuriesData collectionFinal reportBeech G18S · Yakutat, AKThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion, and main landing gear collapse.NTSB CHI99LA254Accident · No injuriesLimited investigationFinal reportBeech G18S · Minneapolis, MNthe premature gear retraction and proper runway alignment not maintained during takeoff by the pilot. An additional cause was the proper descent rate not maintained by the pilot. Contributing factors were the carburetor icing conditionsNTSB FTW98LA007Accident · Serious injuriesLimited investigationFinal reportBeech G18S · Crosbyton, TXInadequate maintenance which resulted in diminished carburetor heat effectiveness due to missing alternate air doors. Contributing were conducive carburetor icing weather conditions, low ceilings during the emergency descent, and the lack of suitable terrain…NTSB ANC97LA046Accident · No injuriesLimited investigationFinal reportBeech G18S · Nome, AKfracture of a propeller blade tip.NTSB MIA97LA036Accident · 1 fatalLimited investigationFinal reportBeech 18G · Roosevelt Roads, PRThe pilot's improper planning/decision concerning separation of the left engine cowling. Factors relating to the accident were: the pilot's failure to perform weight and balance calculations, and/or to ensure the airplane was loaded in accordance with company…NTSB ANC96LA020Accident · Minor injuriesLimited investigationFinal reportBeech G18S · Nome, AKThe pilot exceeding the weight and balance limitations of the airplane and improperly utilizing the airplane's elevator trim by selecting full nose up trim.NTSB FTW95LA154Accident · No injuriesLimited investigationFinal reportBeech G18S · Springdale, AREngine compartment fire due to undetermined reasons.NTSB MIA94LA075Accident · Minor injuriesLimited investigationFinal reportBeech G18S · Fort Lauderdale, FLThe pilot-in-command's improper approach planning and premature extension of the landing gear, resulting in the flight being unable to maintain sufficient altitude and airspeed to reach the runway. The loss of engine power on one engine was a factor.NTSB CHI92FA037Accident · No injuriesField investigationFinal reportBeech G-18S · West Chicago, ILA result of the pilot in command's not maintaining directional control, an improper inflight decision, and improper remedial action once the loss of directional control was recognized by the pilot. Factors contributing to this accident are inadequate cargo…NTSB ANC90LA017Accident · No injuriesLimited investigationFinal reportBeech 18 · Brevig Mission, AKLoss of power in the the right engine for an unknown reason. The rough/uneven terrain was a contributing factor.NTSB MIA90WA015Accident · No injuriesForeign investigationBeech G18S · San Andros, BahamasNTSB MIA89IA247Incident · No injuriesIncident investigationFinal reportBeech G18S · Jackson, MSFailure of the pilot to correctly perform the emergency gear extension procedures. Contributing to the accident was the failure of the normal gear extension system.NTSB MIA89LA224Accident · No injuriesLimited investigationFinal reportBeech 18 · Greenwood, MSInadvertent wheels up landing by the pilot.NTSB ATL89FA098Accident · 1 fatalField investigationFinal reportBeech BE-18 · Covington, KYPilot attempted a takeoff with coating of frost on the airframe which resulted in a loss of lift during climbout.NTSB ATL88LA099Accident · No injuriesLimited investigationFinal reportBeech 18S · Morganton, NCPIC aborted first takeoff attempt due to crosswind induced directional control difficulties. During second takeoff attempt, gusty crosswind lifted left wing & acft became airborne. PIC forced acft back onto rwy, lost directional control and veered off rwy…NTSB MKC86LA074Accident · No injuriesLimited investigationFinal reportBeech G18S · Cedar Rapids, IAThe pilot was aware that he would have a strong crosswind on landing. He was landing on runway 13 with winds from 180 degrees at 20 knots, gusting to 30 knots. The pilot stated that while the airplane was rolling down the runway, the right wing was lifted by…NTSB CHI86FA092Accident · Serious injuriesField investigationFinal reportBeech G18S · Janesville, WIThe aircraft impacted the ground about 1,000 ft to the left of the runway. The pilot stated that he did not have visual contact with the ground & remembers attempting to make a missed approach. Conditions were IMC.NTSB CHI86LA054Accident · No injuriesLimited investigationFinal reportBeech G18S · Minneapolis, MNThe aircraft collided with a snowbank while goundlooping after landing at the completion of a cargo flight from chicago ill. The winds were calm. The pilot stated that he needed to take timely and sufficient action.NTSB NYC85LA018Accident · Minor injuriesLimited investigationFinal reportBeech G18S · Laconia, NHAccording to the plt, shortly after takeoff the acft began to pitch up, decelerate, and roll right. He reduced power and lowered the nose in an unsuccessfull attempt to regain control. There were no mechanical malfunctions reported.NTSB CHI85LA026Accident · No injuriesLimited investigationFinal reportBeech G-18S · Belleville, MIAfter reaching 75 KTS on takeoff roll, the acft ground looped to the left, shearing the main landing gear in side overload. Plt stated left gear seemed to be dragging. Investigation revealed no evidence of pre-existing brake/wheel malfunction or failure.NTSB CHI83FA381Accident · 2 fatalField investigationFinal reportBeech G18S · Evart, MIThe acft collided with a utility pole and a large tree during a forced landing after a power loss on takeoff. Witnesses heard the acft backfiring and the ground run was excessively long. Immediately after takeoff the acft went through the tops of pine trees.…NTSB MIA83LA155Accident · No injuriesLimited investigationFinal reportBeech G18S · Jacksonville, FLThe plt reported that during the landing roll, while rolling on all 3 gear, the tailwheel failed & steered sideways causing the acft to veer off the rwy. An investigation revealed the tailwheel truss axle had failed. A further inspection revealed that 50% of…NTSB MIA83FA121Accident · Minor injuriesField investigationFinal reportBeech G18S · Hollywood, FLThe plt stated that start, taxi & takeoff were normal until after he raised the gear handle & the acft was climbing thru aprx 150 to 200 ft AGL. At that time, he noticed that the left eng RPM was decaying. There was insufficient rwy remaining to abort, so he…NTSB NYC83LA059Accident · No injuriesLimited investigationFinal reportBeech G18S · Wilkes-Barre, PAThe plt lost directional control & collided with a drainage ditch causing the main gear to collapse.NTSB ATL83IA034Incident · No injuriesIncident investigationFinal reportBeech G18S · Huntsville, ALThe left cargo door separated from the acft. The door was a hamilton cargo door installed under an STC which required 3 hinges on top & 3 pins on bottom with an overcenter locking mechanism on the handle for the pins. This door had 2 hinges installed. Only 2…NTSB CHI82DA355Accident · No injuriesFinal reportBeech G18S · Indianapolis, INThe pilot stated that the aircraft veered to the left just after rotation. He pushed the propeller, power and mixture controls forward. The left wing and left main gear struck the ground. The aircraft then began to spin while in ground contact. The left…NTSB CHI82DA316Accident · No injuriesFinal reportBeech G18S · Chicago, ILDuring takeoff on runway 13R, the aircraft swerved to the left just as it obtained tailwheel lift-off speed. The aircraft then struck a dirt bank and was damaged. Both the pilot and the aircraft operator stated that the left main tire lost pressure, but they…NTSB MIA82IA002Accident · No injuriesClosedBeech G18S · Jacksonville, FLNTSB NYC81FA056Accident · No injuriesClosedBeech G18S · New Cumberland, PANTSB NYC81FA050Accident · 2 fatalClosedBeech G18S · Hyannis, MANTSB CHI81IA049Incident · No injuriesClosedBeech G18S · Chicago, ILNTSB MIA81FA041Accident · No injuriesClosedBeech G18S · San Juan, PRNTSB ATL81FA027Accident · Serious injuriesClosedBeech G-185 · Atlanta, GANTSB MIA79FA084Accident · No injuriesClosedBeech G18S · San Juan, PRNTSB NYC79IA039Incident · No injuriesClosedBeech BE-18 · Newburgh, NYNTSB OAK79FA013Accident · 2 fatalClosedBeech G18S · Sacramento, CANTSB MKC79FA004Accident · 2 fatalClosedBeech G18S · Hays, KSNTSB MIA78DLD76Accident · Minor injuriesClosedBeech G18S · Nnassau (Atlantic Ocean)NTSB FTW78DRG59Accident · Minor injuriesClosedBeech G18S · Mc Allen, TXNTSB IAD78FA046Accident · Serious injuriesClosedBeech B18G · Rockingham, NCNTSB CHI78FA017Accident · No injuriesClosedBeech G-18S · West Chicago, ILNTSB CHI78FEI02Accident · No injuriesClosedBeech G-18S · Cleveland, OHNTSB MIA77FA081Accident · 1 fatalClosedBeech G18S · Aero Oasis Apt, FLNTSB NYC77FA082Accident · Serious injuriesClosedBeech G18S · Pittsburgh, PANTSB ANC77DAH08Accident · No injuriesClosedBeech G18S · Anchorage, AKNTSB NYC77DNC36Accident · No injuriesClosedBeech 18G · Burlington, VTNTSB ANC77DA034Accident · No injuriesClosedBeech G18S · Tyonek, AKNTSB CHI77FA024Accident · No injuriesClosedBeech G18S · Youngstown, OH
Back to Beech G18S