Final NTSB investigations: Kawasaki ALL MDLS A/B
9 cases on aircraft whose registry engine model is Kawasaki ALL MDLS A/B. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1983 | 2 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1993 | 2 |
| 1995 | 1 |
Where
Open the mapLatest cases
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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE c.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('35500'))
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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('35500'))
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 ATL95LA153Accident · No injuriesLimited investigationFinal reportYothment KOLB-FIRESTAR II · Lawrenceville, GAThe pilot's failure to maintain flying speed. A factor was the pilot's lack of familiarity with the aircraft.NTSB CHI93DER02Accident · No injuriesFinal reportMiller Quickie · Glencoe, MNThe disconnection of the ignition switch wiring.NTSB CHI93DEX01Accident · No injuriesFinal reportZeigler Moni · Seymour, INan inadvertent stall. Factors relating to the accident are the major alteration of the airframe, and failure of the pilot-in- command to obtain new performance data.NTSB SEA89LA083Accident · Serious injuriesLimited investigationFinal reportDavis Starship Alpha · Star, IDFailure of the propeller drive belt (stripped teeth). Contributing factors were: strong/gusty winds and the hilly terrain.NTSB SEA87LA146Accident · No injuriesLimited investigationFinal reportDavis Starship Alpha · Burley, IDA loss of power occurred shortly after takeoff at about 100 feet AGL. Due to obstacles in the pilot's flight path landing had to be made in a river where the aircraft was substantially damaged. The reason for the power loss could not be determined.NTSB MIA85LA114Accident · Minor injuriesLimited investigationFinal reportMitchell Harvey Condor III +2 · Lake Placid, FLThe plt stated that on takeoff from lake persommon he was unable to climb more than 50 fpm due to downdrafts along the tree line on his right side & he collided with a 35 ft tree & crashed into a creek.NTSB MIA84LA079Accident · No injuriesLimited investigationFinal reportHarvey Condor 3+2 · Lake Placid, FLThe acft was damaged in a forced landing after the engine lost power. The plt reported that a parachute line contacted the engine on/off switch and shut off the engine.NTSB LAX83LA443Accident · Minor injuriesLimited investigationFinal reportFueslein Quickie · San Andreas, CAThe home built acft was equipped with a kawasaki TA-440A eng & an unspecified propeller, both of which were different than the original plans called for. The plt stated that on the 1st test flt with the new eng & prop combination, the eng RPM & thrust would…NTSB MIA83FA208Accident · Serious injuriesField investigationFinal reportCondor II · Perrine, FLThe plt was on a flt to test a new liquid cooled eng & its radiator size & location. On previous flts, he had noted inadequate cooling. Company personnel had moved the radiator to improved its efficiency. On the previous flt, the plt noted that the temp gage…