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 ('1151602')
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 ('1151602')
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 ANC26LA085Accident · No injuriesClass 4 · LimitedInvestigation openBeech 36 · Port Alsworth, AKNTSB CEN22LA407Accident · No injuriesClass 4 · LimitedFinal reportBeech 36 · Tupelo, MSThe pilot’s failure to extend the landing gear for a landing.NTSB WPR18TA243Accident · No injuriesFinal reportBeech 36 · Kelso, WAThe pilot's fuel mismanagement, which led to fuel starvation, a total loss of engine power, and the subsequent forced landing to a field.NTSB ERA17LA041Accident · Serious injuriesLimited investigationFinal reportBeech 36 · Ormond Beach, FLA loss of aircraft control for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical malfunctions or failures of the flight controls that would have precluded normal operation.NTSB WPR15FA088Accident · 2 fatalField investigationFinal reportBeech 36 · Mountain Pass, CAAn in-flight loss of control for reasons that could not be determined based on available information.NTSB WPR11CA468Accident · No injuriesData collectionFinal reportBeech 36 · Riverton, WYThe pilot's inadvertent retraction of the landing gear during the landing roll.NTSB ERA09FA093Accident · 1 fatalField investigationFinal reportBeech 36 · Louisville, KYThe pilot’s continued operation of the aircraft with known deficiencies. Contributing to this accident was the improper sealing of the engine case during overhaul.NTSB LAX07CA244Accident · No injuriesData collectionFinal reportBeech 36 · Jean, NVA loss of engine power for undetermined reasons.NTSB DEN07FA002Accident · Minor injuriesField investigationFinal reportBeech 36 · Centennial, COthe loss of engine power for undetermined reasons. Contributing factors were the light pole and parked vehicles impacted during the forced landing.NTSB LAX06FA066Accident · 2 fatalField investigationFinal reportBeech 36 · Livermore, CAThe pilot's failure to maintain the appropriate glidepath alignment during an instrument landing system approach, resulting in collision with terrain. A contributing factor to the accident was the failure of the air traffic controllers to issue a minimum safe…NTSB DFW05FA059Accident · 2 fatalField investigationFinal reportBeech BE-36 · Brownwood, TXThe pilots failure to maintain proper altitude and clearance while on final approach to land. Contributing factors were the pilot's lack of familiarity with the geographic area, the dark night light conditions, the non-availability of a visual approach glide…NTSB ANC04FA070Accident · 1 fatalField investigationFinal reportBeech 36 · Talkeetna, AKThe pilot's failure to maintain clearance from terrain during cruise flight, which resulted in an in-flight collision with terrain.NTSB NYC03CA149Accident · No injuriesData collectionFinal reportBeech BE36 · Block Island, RIThe pilot misjudged speed and distance while landing, which resulted in an overrun. A factor in the accident was a wet runway.NTSB MIA03FA068Accident · 1 fatalField investigationFinal reportBeech 36 · Captiva Island, FLThe pilot's VFR flight into instrument meteorological conditions and his ensuing failure to maintain altitude/clearance resulting in an in-flight collision with the ocean. A factor was the fog.NTSB MIA01LA082Accident · 4 fatalLimited investigationFinal reportBeech 36 · Tybee Island, GAThe flights entry into a descending right turn for undetermined reasons resulting in the flight crashing into the ocean.NTSB ATL00LA013Accident · No injuriesLimited investigationFinal reportBeech BE36 · Daytona Beach, FLThe collapse of the main landing gear for undetermined reasons.NTSB LAX99FA150Accident · 2 fatalField investigationFinal reportBeech 36 · San Diego, CAThe pilot's failure to maintain the proper glidepath during an ILS approach. A factor in the accident was the pilot's disregard for the weather reports, which showed the airport as being below landing minimums.NTSB LAX99LA015Accident · Minor injuriesLimited investigationFinal reportBeech 36 · Palmdale, CAThe pilot's improper management of his fuel supply which resulted in fuel starvation. Factors in the accident were the inadequate annual inspection which resulted in fuel siphoning, and a high reading fuel gage.NTSB LAX93LA218Accident · No injuriesLimited investigationFinal reportBeech 36 · Hayward, CAfuel starvation due to the pilot's inadequate preflight inspection of the aircraft and his failure to ensure that adequate fuel existed in the fuel tanks to be used.NTSB BFO90FA053Accident · 2 fatalField investigationFinal reportBeech 36 · Gaithersburg, MDFailure of the pilot to extend the landing gear, which resulted in a wheels up landing; his improper decision to attempt a go around (aborted landing) after the airplane contacted the runway; and his failure to attain or maintain adequate airspeed while…NTSB CHI89LA195Accident · No injuriesLimited investigationFinal reportBeech 36 · Princeton, ILThe pilot had excessive airspeed, misjudged the landing distance, and did not go around. The high obstructions (trees),wet runway, ditch, and uneven terrain (roadway) were contributing factors.NTSB MKC87LA040Accident · Minor injuriesLimited investigationFinal reportBeech A-36 · Corning, IAThe flt had progressed normally from champagne, IL. The IFR flt plan was cancelled at lamoni VOR and the flt proceeded VFR. On final approach to rwy 17, aprx 1 mile from the rwy, the altimeter suddenly unwound and the acft struck trees. The altimeter had…NTSB MIA86LA201Accident · Minor injuriesLimited investigationFinal reportBeech 36 · Marco Island, FLDuring landing apch, the plt stated that he switched from the left fuel tank to the right tank & shortly thereafter, the eng failed. He was unable to restart the eng and a forced ldg was made. An exam of the left tank revealed it to be empty while the right…NTSB NYC85LA172Accident · No injuriesLimited investigationFinal reportBeech 36 · Calverton, NYThe pilot of N9031S was advised that nantucket memorial airport was in IFR conditions and decided to turn back towards long island. During the flight to long island, N9031S lost radio communications and soon electrical power to the navigational equipment. The…NTSB SEA85LA095Accident · 2 fatalLimited investigationFinal reportBeech 36 · Elko, NVElko DME (located at the arpt, used for the lda/dme apch, 108.5 mhz) was inop. Drg arrival, the plt expressed mistrust of his DME. Aprx 24 mi sse of bullion (bqu) VOR, ARTCC controller (ctlr) clrd N7514N for 'the apch to the Elko arpt.' Seconds later, the plt…NTSB CHI83LA151Accident · No injuriesLimited investigationFinal reportBeech A-36 · Columbus, OHThe aircraft landed in a field about 1 mile from the approach end of the runway after engine stoppage during final approach. No malfunction of the engine was found during examination. The pilot stated he had flown about 3 hrs and 20 minutes. The hobbs meter…NTSB CHI82DA257Accident · No injuriesFinal reportBeech 36 · Ypsilanti, MIAfter the engine was started, the pilot found that he needed a new microphone. He stated that he leaned over to the right to help the passenger open the door and apparently bumped the throttle. The aircraft moved and struck a parked Grumman American AA-5A,…NTSB NYC82FA005Accident · Minor injuriesClosedBeech 36 · Marlborough, NYNTSB DEN78FA044Accident · 4 fatalClosedBeech 36 · Granite, CONTSB CHI78DEX03Accident · Serious injuriesClosedBeech 36 · Terre Haute, INNTSB MIA77FLA51Accident · No injuriesClosedBeech 36 · Keystone Hts, FLNTSB OAK76AP063Accident · No injuriesClosedBeech 36 · Castro Valley, CANTSB MKC76DCG62Accident · No injuriesClosedBeech 36 · Camdenton, MONTSB NYC76DNC42Accident · Minor injuriesClosedBeech A36 · Stowe, VTNTSB SEA75FYI04Accident · Serious injuriesClosedBeech 36 · Klamath Fls, ORNTSB FTW72FQG18Accident · No injuriesClosedBeech 36 · Sudan, TXNTSB FTW71AF057Accident · 6 fatalClosedBeech 36 · Harrison, ARNTSB LAX71DUJ37Accident · Minor injuriesClosedBeech 36 · Tucson, AZNTSB CHI70AC069Accident · 4 fatalClosedBeech 36 · Gary, INNTSB OAK70F0193Accident · Serious injuriesClosedBeech 36 · Mammoth Lks, CANTSB FTW70F0096Accident · No injuriesClosedBeech 36 · Houston, TXNTSB FTW69F0552Accident · No injuriesClosedBeech 36 · Tulsa, OKNTSB DEN69D0126Accident · No injuriesClosedBeech 36 · Denver, CONTSB DEN69F0038Accident · No injuriesClosedBeech 36 · Socorro, NM
Back to Beech 36