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 ('1151012')
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 ('1151012')
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 CEN09CA474Accident · No injuriesData collectionFinal reportBeech H-18 · Dayton, OHThe pilot's failure to lock the tailwheel during landing resulting in the loss of directional control.NTSB NYC07FA234Accident · Serious injuriesField investigationFinal reportBeech H-18 · Ft. Lauderdale, FLA total loss of engine power due to fuel starvation as a result of the pilot's failure to place the fuel selector for the right engine in the proper position. Contributing to the accident was the improper loading of the cargo.NTSB DEN07FA059Accident · 1 fatalField investigationFinal reportBeech H-18 · Great Bend, KSThe pilot's failure to maintain aircraft control during the missed approach which resulted in an inadvertent stall and impact with terrain. A contributing factor was the icing conditions.NTSB NYC04LA040Accident · No injuriesLimited investigationFinal reportBeech H-18 · Westminster, MDThe pilot's failure to maintain control of the airplane after a failure of one propeller system. Factors in the accident were the failure to perform maintenance inspection and the failure of a bolt in the left propeller blade system.NTSB FTW02FA195Accident · 1 fatalField investigationFinal reportBeech H-18 · Tatum, NMThe failure of the pilot to maintain clearance.NTSB LAX97FA108Accident · Minor injuriesField investigationFinal reportBeech H18 · Honolulu, HIloss of aircraft control for undetermined reason(s).NTSB ATL92FA049Accident · 1 fatalField investigationFinal reportBeech H-18 · Morganton, NCThe failure of the pilot to follow FAR and company procedures, and his failure to maintain proper altitude during the approach. Factors were the mountainous terrain conditions, and the foggy, low ceiling weather conditions existing at the time of the accident.NTSB LAX92LA116Accident · No injuriesLimited investigationFinal reportBeech D-18H · Lanai, HIFailure of the pilot to compensate for an encounter with a windshear phenomena. Contributing to the accident was the lack of a low level windshear warning system or a system for the collection and dissemination of weather advisories.NTSB ANC91LA133Accident · No injuriesLimited investigationFinal reportBeech B-18H · White Mountain, AKThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB ANC90LA169Accident · No injuriesLimited investigationFinal reportBeech H-18S · Deering, AKThe pilot-in-command's failure to maintain directional control of the airplane on landing.NTSB MIA90WA095Accident · No injuriesForeign investigationBeech H-18 · Nassau, BahamasNTSB DCA89MA058Accident · 11 fatalMajor investigationFinal reportBeech H18 · Waipio Valley, HIThe pilot's improper in-flight planning/decision to maneuver with insufficient altitude over or in a a canyon area. Factors related to the accident were: the terrain conditions and scenic air tour's lack of specific direction to its pilots concerning safety…NTSB NYC88LA152Accident · No injuriesLimited investigationFinal reportBeech H18 · Utica, NYThe flight had departed syracuse airport enroute to plattsburg, new york transporting ups packages. At about 0810 hours, a loss of power on the left engine was experienced and altitude could not be maintained. The pilot informed griffiss control that he could…NTSB MKC88FA072Accident · 1 fatalField investigationFinal reportBeech H18 · Kansas City, MOThe cargo flt dptd cincinnati enrt to wichita, KS with an intermediate stop at Kansas City dtwn arpt. The flt progressed nrmly to a VOR rwy 03 instrument apch, circling to rwy 01. The PIC had been clrd to commence the apch. Twr pers subsequently advised the…NTSB ATL88LA006Accident · No injuriesLimited investigationFinal reportBeech H-18 · Sandersville, GAThe cockpit began to fill with smoke during initial climb after the plt raised the ldg gear. The plt returned to the arpt and made an emergency ldg. After evacuating the acft, the plt observed that the rt engine nacelle aft of the firewall was on fire.…NTSB CHI87FA219Accident · 1 fatalField investigationFinal reportBeech H-18 · Rockford, ILThe commercial pilot was on a repositioning flight from kenosha, Wisconsin to atlanta, Georgia, after having been without sleep for about 20 hours. Witnesses observed the aircraft circling a subdivision near Rockford, Illinois at a low altitude, just above…NTSB NYC87LA031Accident · No injuriesLimited investigationFinal reportBeech BE18H · Pittsburgh, PAThe aircraft suffered a right landing gear leg breakage due to a fracture in the area where the fork assembly separated during landing roll.NTSB ATL86FLQ05Accident · Serious injuriesFinal reportBeech H-18 · Louisville, KYThe acft collided with the ground after stalling during takeoff. Witnesses reported that the acft pitched up in two increments, climbed sharply to about 200 ft AGL, stalled dropped the rt wing and descended, impacting the ground in a flat attitude.NTSB FTW86FA004Accident · 2 fatalField investigationFinal reportBeech H18 · Oklahoma City, OKAtr plt departing arpt under VMC experienced failure of the right eng shortly after lift-off. The acft yawed right followed by a steep right roll, contacting power lines with the right wing and subsequently impacted the ground. A post-crash fire destoyed the…NTSB MKC86LA013Accident · No injuriesLimited investigationFinal reportBeech H-18 · Osage Beach, MOOn fianl approach to land on rwy 14 at the linn creek/grand glaize airport the plt began to apply prw to the two engines to arrest the descent of the approach. The plt finally had full pwr applied but the acft impacted. The ground short of the rwy. The plt…NTSB LAX85LA138Accident · No injuriesLimited investigationFinal reportBeech BE-18 · Santa Maria, CAThe plt reptd that during the landing rollout on rwy 30, a gust of wind caused the acft right wing to lift. The plt was unable to correct the uplifting wing and the acft entered into a left groundloop maneuver & exited the rwy. The local controller reported…NTSB CHI85IA091Incident · No injuriesIncident investigationFinal reportBeech H-18 · Dayton, OHThe acft was rotated prematurely and stalled back onto the rwy. The acft was on rwy 24L and the wind was 240 degrees at 17 KTS gusting to 24 KTS. There was slight damage to the landing gear & flapsNTSB NYC84FA113Accident · 1 fatalField investigationFinal reportBeech H-18 · Morrisonville, NYThe plt landed on the ice and snow covered rwy after loading 1512 lbs of cargo in freezing drizzle conditions, he taxied for takeoff for an IFR departure shortly after rotation, the right wing dropped and the acft touched down back onthe rwy. Visual exam of…NTSB NYC84FA037Accident · 2 fatalField investigationFinal reportBeech H18 · Allentown, PAWhile en route, the plt encountered icing conditions, then reported he was unable to maintain alt & was having eng problems. He diverted toward Allentown, PA, then advised he had lost power in the left eng. Apch control began issuing vectors for a VOR apch;…NTSB LAX83LA427Accident · Serious injuriesLimited investigationFinal reportBeech H18S · Kailua-Kona, HIAbout 1 min after takeoff, between 400-500 ft MSL & during the first power reduction, the right eng backfired. Followingsome more violent backfires the RPM went to zero. The right eng was restarted but the same result occurred. The plt attempted to feather…NTSB ATL83LA101Accident · No injuriesLimited investigationFinal reportBeech H18 · Talladega, ALThe plt stated that shortly after full power application & prior to tailwheel lift-off, the 'right wing raised aprx 3 to 4 ft into the air.' The acft then began drifting left. During ensuing maneuvers, the plt alternately advanced & retarded the throttle as…NTSB LAX82FA224Accident · No injuriesField investigationFinal reportBeech H-18 · Fresno, CAJust after lift-off from rwy 29R, the acft began to pitch up. As the pitch-up progressed, the plt applied right aileron & full right rudder. The acft responded by rolling to the right with the nose falling thru. Subsequently, the plt was able to pull out…NTSB DEN81FTC25Accident · Minor injuriesClosedBeech H18S · Gillette, WYNTSB CHI81IA075Incident · No injuriesClosedBeech 18 · Detroit, MINTSB ATL81FKG13Accident · No injuriesClosedBeech H18 · Atlanta, GANTSB NYC81FA031Accident · Minor injuriesClosedBeech H18 · Hazelton, PANTSB LAX81FA042Accident · 2 fatalClosedBeech H18 · Newhall, CANTSB CHI81DA018CaseClosedBeech H18S · Chicago, ILNTSB NYC81FA010Accident · 1 fatalClosedBeech H18 · Troxelville, PANTSB MKC80FA023Accident · 1 fatalClosedBeech H18 · Olathe, KSNTSB IAD80FLQ04Accident · No injuriesClosedBeech H18S · Covington, KYNTSB NYC79FA021Accident · No injuriesClosedBeech H18 · Pittsburgh, PANTSB FTW79FA015Accident · 1 fatalClosedBeech H18 · Brownsville, TXNTSB OAK78FJA07Accident · No injuriesClosedBeech H18 · Molakai, HINTSB MIA78FKJ28Accident · No injuriesClosedBeech H18 · Birmingham, ALNTSB CHI78FA031Accident · 3 fatalClosedBeech H18 · Centreville, ILNTSB ANC77DA048Accident · No injuriesClosedBeech H-18 · Noatak, AKNTSB OAK76AP043Accident · 1 fatalClosedBeech H18 · Pacific Ocean (Pacific Ocean)NTSB CHI75AC065Incident · No injuriesClosedBeech H18 · Grayling, MINTSB CHI75FEM27Accident · No injuriesClosedVolpar H18 · Saginaw, MINTSB IAD75AI038Accident · 2 fatalClosedBeech H18 · St Augustine, FLNTSB CHI75AC033Accident · 1 fatalClosedBeech H18 · Iron Mtn, MINTSB CHI75AC001Accident · 1 fatalClosedBeech H18 · Iron Mtn, MINTSB OAK74AP053Accident · 11 fatalClosedBeech H18S · Hilo, HINTSB MIA74FKT27Accident · Serious injuriesClosedBeech H18 · Ft Lauderdale, FL
Back to Beech H-18