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 ('1182202')
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 ('1182202')
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 GAA15CA230Accident · Minor injuriesData collectionFinal reportBell 412 · Whittier, CAThe pilot's failure to appropriately monitor the helicopter's fuel supply, resulting in fuel exhaustion, loss of engine power, and an autorotation with a hard landing.NTSB LAX07FA056Accident · 3 fatalField investigationFinal reportBell 412SP · Hesperia, CAThe pilot's inadvertent encounter with instrument meteorological conditions and subsequent failure to maintain terrain clearance. Contributing to the accident were the dark night conditions, fog, and mountainous terrain.NTSB FTW04IA217Incident · No injuriesIncident investigationFinal reportBell 412 · South Pass 65The failure and separation of the tail rotor gearbox for undetermined reasons.NTSB FTW04LA133Accident · No injuriesLimited investigationFinal reportBell 412 · San Antonio, TXThe pilot's failure to maintain clearance with the parked helicopter while performing a hovering turn.NTSB CHI02LA232Accident · 1 fatalLimited investigationFinal reportBell 412 · Rantoul, ILThe congested takeoff and landing area and the low altitude flight maneuver performed by the pilot.NTSB DEN01FA058Accident · 1 fatalField investigationFinal reportBell 412SP · Grand Junction, COthe pilot's failure to maintain rotor speed during an intentional autorotation, which resulted in a loss of control.NTSB LAX00GA297Accident · 1 fatalFinal reportBell 412 · Cold Springs, NVfailure of the compressor turbine disc due to cyclic fatigue brought about by repeated operation near or above the engines' temperature/power limits by company personnel over an extended period of time. Factors in the accident were: 1) the high density…NTSB FTW99LA162Accident · No injuriesLimited investigationFinal reportBell 412 · Eugene Is. 313The separation of a section of the tail rotor blade, and subsequent separation of the tail rotor system, as a result of fatigue cracking due to corrosion in the tail rotor blade spar.NTSB BFO94FA071Accident · 4 fatalField investigationFinal reportBell 412/SP · Bluefield, VAThe pilot's failure to intercept the final approach course, and his improper execution of the instrument approach procedure. Factors which contributed to the accident were: the weather conditions, and the failure of the air traffic controller to adequately…NTSB FTW94LA043Accident · Minor injuriesLimited investigationFinal reportBell 412 · Cameron, LAThe copilot's continued flight into adverse weather conditions, and the captain's inadequate supervision. The haze and fog were factors.NTSB LAX93T#A02Accident · No injuriesClass 3Final reportBell 412 · Topanga, CANTSB FTW91FA155Accident · 1 fatalField investigationFinal reportBell 412 · Garden BanksOverheating and subsequent failure of the number one tail rotor hanger bearing for an undeterined reason, and failure of the tail rotor drive shaft.NTSB FTW91IA143Incident · No injuriesIncident investigationFinal reportBell 412 · Rowan MidlandThe mechanic's failure to assemble the tail rotor drive shaft correctly and the subsequent failure of the tail rotor drive shaft. A factor was the lack of inspection procedures for offshore maintenance.NTSB DCA91MA031Accident · 7 fatalClass 1 · MajorFinal reportBell 412SP · Merion, PAThe poor judgement by the captain of the airplane to permit the in-flight inspection after he had determined to the best of his ability that the nose landing gear was fully extended, the poor judgment of the captain of the helicopter to conduct the…NTSB ANC89FA069Accident · Minor injuriesField investigationFinal reportBell 412 · Girdwood, AKA main rotor flight control bolt (part number 20-057-6-38D) came out of its rod end bearing while in flight due to the bolt being improperly torqued during maintenance.NTSB FTW88FA036Accident · Serious injuriesField investigationFinal reportBell 412 · Galveston, TXThe acft landed hard in the gulf of Mexico during an autorotation that was entered following the separation of the 90 degree gearbox. The gearbox (with tail rotor blades) separated due to an imbalance. However, the gearbox was not recovered during the…NTSB FTW83IA053Incident · No injuriesIncident investigationFinal reportBell 412 · Intercoastal Ci, LAWhile in cruise flight, the pilots heard a loud pop and felt a severe cyclic control vibration. An immediate precautionary landing was made. An examination revealed that there was a fatigue crack in the trailing edge of the blue, main rotor yoke flexure, pn…
Back to Bell 412