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 ('5110302')
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 ('5110302')
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 ERA24LA324Accident · No injuriesClass 4 · LimitedFinal reportLake LA4 · Catskill, NYThe pilot’s failure to maintain control of the airplane during a takeoff from water in gusting wind conditions.NTSB WPR21LA312Accident · Minor injuriesClass 4 · LimitedFinal reportLake LA-4 · Lake Isabell, CAThe pilot’s failure to establish a positive climb rate after takeoff, which resulted in an impact with an object.NTSB WPR17LA165Accident · No injuriesClass 3 · LimitedFinal reportLake LA 4 · Byron, CAThe pilot’s failure to activate the hydraulic system during the approach, and his failure to ensure that the landing gear was down and locked before touchdown. Contributing to the accident was the pilot's decision to operate the airplane with an inoperative…NTSB ERA14CA225Accident · Minor injuriesData collectionFinal reportLake LA-4 · Chapin, SCThe pilot's improper flare, which resulted in abnormal contact with the water and separation of the right pontoon..NTSB ERA13CA413Accident · No injuriesData collectionFinal reportLake LA-4 · Monticello, KYAn encounter with a large wave during water taxi, which resulted in the airplane nosing over.NTSB CEN12LA661Accident · No injuriesLimited investigationFinal reportLake LA4 · Kenosha, WIThe loss of engine power for reasons that could not be determined because examination and test run of the engine did not reveal any anomalies that would have precluded normal operation.NTSB CHI08CA298Accident · No injuriesData collectionFinal reportLake LA-4 · Algonac, MIThe amphibious airplane's collision with submerged debris during taxi for takeoff, and the resulting damage to the hull.NTSB MIA00LA240Accident · Serious injuriesLimited investigationFinal reportLake LA-4 · Pensacola, FLThe pilot receiving instruction failure to achieve the proper touch down point during a water landing, and the CFI's improper supervision and failure to initiate a go-around in sufficient time to avoid and in-flight collision with trees, water, and subsequent…NTSB CHI99LA339Accident · Serious injuriesLimited investigationFinal reportLake LA-4 · Ann Arbor, MIThe pilot's improper touchdown during a water landing.NTSB SEA99LA063Accident · No injuriesLimited investigationFinal reportLake LA-4 · Coeur D'Alene, IDThe fatigue failure of a repair weld on one of the engine pylon mount straps and the resultant reduction in directional control. Factors include an inadequate repair of the strap, variable wind speeds and sudden wind shifts.NTSB ANC98LA073Accident · No injuriesLimited investigationFinal reportLake LA-4 · Saint Mary'S, AKThe pilot's diverted attention during takeoff, and his failure to maintain a proper climb rate. A factor associated with the accident was the presence of birds.NTSB NYC97LA027Accident · No injuriesLimited investigationFinal reportLake LA-4 · Gallipolis, OHthe pilot's improper recovery from a bounced landing, and his failure to maintain directional control, which resulted in a collision with a hangar and parked aircraft. Factors relating to the accident were: the pilot's encounter with rain, sleet, snow, and…NTSB ANC93LA136Accident · No injuriesLimited investigationFinal reportLake LA04 · Blair Lake, AKThe pilot's inadvertant entry into a porpoise and subsequent loss of control while step-taxiing prior to takeoff. A factor in the accident was the rough water conditions.NTSB CHI92LA128Accident · Minor injuriesLimited investigationFinal reportLake LA-4 · Lee'S Summit, MOA delayed aborted takeoff by the pilot in command. A factor in the accident is the presence of carburetor icing conditions.NTSB MIA92LA009Accident · Minor injuriesLimited investigationFinal reportLake LA-4 · Panama City, FLLoss of power due to undetermined reasons. Contributing to the accident was the cfi's inadequate emergency procedures following the reported loss of power.NTSB NYC91LA243Accident · No injuriesLimited investigationFinal reportLake LA-4 · Wilton, METhe pilot's improper recovery from a bounced landing on rough water which resulted in the right wing tip contacting the water causing the airplane to nose over and sink. Factors related to the accident were, the pilot's low time and experience in this type…NTSB SEA90FA171Accident · 3 fatalField investigationFinal reportLake LA-4 · Onalaska, WAImproper in-flight planning/decision by the pilot, and his inadvertent flight into instrument meteorological conditions (IMC). Factors related to the accident were: the adverse weather and terrain conditions.NTSB NYC88LA176Accident · No injuriesLimited investigationFinal reportLake LA-4 · Linden, NJHard landing due to improper level off of the student and the flight instructor's inadequate supervision. The left wing partially failed because of overload and the aircraft made a forced landing in a swamp.NTSB ANC87LA098Accident · No injuriesLimited investigationFinal reportLake LA-4 · Cool Lake, AKThe pilot stated that during the takeoff on the Lake the aircraft would not lift off the water and he lost directional control of the aircraft causing it to collide with the Lake shore.NTSB BFO87DIA01Accident · No injuriesFinal reportLake LA-4 · Stafford, VADuring takeoff the aircraft collided with a submerged object which penetrated the hull and dislodged the right pontoon. The aircraft sank in approximately 4 feet of water and was substantially damaged. The pilot and his two passengers were not injured. A boat…NTSB LAX87LA019Accident · Serious injuriesLimited investigationFinal reportLake LA4-180 · Folsom, CADuring a local cross country pleasure flight, the pilot attempted a landing on Lake Folsom. Upon touchdown the aircraft began settling in the water then nosed over and sank. The pilot stated he felt there was an object in the water that was struck. Witnesses…NTSB NYC85LA188Accident · No injuriesLimited investigationFinal reportLake LA-4 · Sidney, MEAccording to the plt, the acft was on step and in indicating about 45 KTS airspeed. It then encountered a boat wake and began flying. The acft porpoised 2 or 3 times and then collided with the water in an estimated 10 to 15 deg nose down attitude. The pwr was…NTSB SEA84LA076Accident · No injuriesLimited investigationFinal reportLake LA-4 · Alderwood Manor, WAAccording to a witness, he observed the acft from taxi to takeoff, then from base throughout the landing. He observed the acft with the gear down on base leg & said the plt flew a low & short final apch. He stated the plt cut power short of the rwy & the acft…NTSB MIA83LA193Accident · No injuriesLimited investigationFinal reportLake LA-4 · Gainesville, FLThe plt stated that during takeoff, the eng appeared to lose power at about 200 ft AGL, but the gauges showed no malfunction. The acft began to settle, so he elected to land on the rwy overrun area. Reportedly, the acft was landed successfully, however, while…NTSB MIA83LA167Accident · No injuriesLimited investigationFinal reportLake LA-4 · Jacksonville, FLThe acft collided with a tree and landed gear up on floats after an engine failure. The pilot was cruising at 1000 ft MSL when the oil pressure dropped to zero and the engine seized. The acft collided with the tops of pine trees while approaching a nearby…NTSB FTW82DA296Accident · No injuriesFinal reportLake LA-4 · Springdale, ARDuring takeoff from a touch-and-go landing, the engine went to about idle power. During a forced landing, the left wing and nose collided with trees. Reportedly, the engine started developing full power just as the aircraft collided with trees. No mechanical…NTSB ANC81DAG34Accident · No injuriesClosedLake LA-4 · Cordova, AKNTSB NYC81FA025Accident · 1 fatalClosedLake LA-4 · Middleboro, MANTSB NYC80FNE02Accident · No injuriesClosedLake LA-4 · Griswold, CTNTSB NYC79FA040Accident · 1 fatalClosedLake LA-4 · Jonesboro, MENTSB NYC79FHD06Accident · Serious injuriesClosedLake LA-4 · North Beach, NJNTSB NYC79FNA02Accident · No injuriesClosedLake LA-4 · Tuckernuck Isl, MANTSB ANC79DAD02Accident · No injuriesClosedLake LA-4 · Harding Lake, AKNTSB MIA78DLG31Accident · Minor injuriesClosedLake LA-4 · Lexington, SCNTSB FTW78FRG58Accident · No injuriesClosedLake LA-4 · San Antonio, TXNTSB MIA78FA053Accident · 1 fatalClosedLake LA-4 · Pierson, FLNTSB OAK78FA014Accident · 1 fatalClosedLake LA-4 · Hawthorne, NVNTSB FTW77FRG20Accident · No injuriesClosedLake LA-4 · San Antonio, TXNTSB NYC76DNC63Accident · Serious injuriesClosedLake LA-4 · Derry, NHNTSB CHI76DET22Accident · No injuriesClosedLake LA-4 · Angola, INNTSB SEA7LFYE18Accident · Serious injuriesClosedLake LA-4 · Alderwood Mnr, WANTSB LAX76FUA08Accident · No injuriesClosedLake LA-4 · Long Beach, CANTSB CHI75FEC59Accident · No injuriesClosedLake LA-4 · E Lansing, MINTSB MIA74FLA47Accident · No injuriesClosedLake LA-4 · Jacksonville, FLNTSB ANC74FAD16Accident · No injuriesClosedLake LA-4 · Petersburg, AKNTSB NYC74FNA24Accident · No injuriesClosedLake LA-4 · Norwood, MANTSB FTW74DPD04Accident · Minor injuriesClosedLake LA-4 · Azle, TXNTSB NYC74FNC12Accident · No injuriesClosedLake LA-4 · Bethel, MENTSB MKC73DCA23Accident · No injuriesClosedLake LA-4 · St Charles, MONTSB MIA73DKT78Accident · No injuriesClosedLake LA-4 · Key West, FL
Back to Lake LA-4