Final NTSB investigations: Schleicher KA 6 CR
13 cases on aircraft the registry lists as Schleicher KA 6 CR. 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
| 1964 | 1 |
|---|---|
| 1966 | 2 |
| 1967 | 1 |
| 1968 | 1 |
| 1970 | 2 |
| 1973 | 1 |
| 1976 | 1 |
| 1979 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 1996 | 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.aircraft_model_code IN ('3801537'))
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.aircraft_model_code IN ('3801537'))
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 FTW96LA330Accident · No injuriesLimited investigationFinal reportSchleicher KA6-CR · Forrest City, ARthe pilot's failure to abort the takeoff. Factors were the dust restricting his visibility and the uneven terrain.NTSB CHI87LA142Accident · No injuriesLimited investigationFinal reportSchleicher KA-6-CR · Staunton, ILThe plt stated that he climbed to 6000 feet MSL and proceeded on course to Staunton, Illinois. According to the plt in a telephone interview, he was approximately 800-900 feet above willhoit airport when he made a 360 degree turn to enter base. He further…NTSB ATL84FMG01Accident · Serious injuriesFinal reportSchleicher KA6CR · Marion, NCThe plt attempted a 360 deg turn prior to landing, while at a low altitude and crashed after aprx 150 to 180 degs of the turn.NTSB IAD79DKM05Accident · Serious injuriesClosedSchleicher KA6CR · Marion, NCNTSB LAX76DNQ27Accident · Minor injuriesClosedSchleicher KA6CR · Santa Ynez, CANTSB CHI73FEM65Accident · No injuriesClosedSchleicher KA6CR · Ionia, MINTSB LAX71DUG29Accident · No injuriesClosedSchleicher KA-6CR · Boron, CANTSB MIA71DLD02Accident · No injuriesClosedSchleicher KA-6CR · Apopka, FLNTSB SEA69D0114Accident · No injuriesClosedSchleicher KA6CR · Dallesport, WANTSB CHI68D0096Accident · No injuriesClosedSchleicher KA-6CR · Genoa, OHNTSB NYC67D0311Accident · Minor injuriesClosedSchleicher KA-6 · Gorham, NHNTSB MIA67D0181Accident · Serious injuriesClosedSchleicher KA-6CR · Johnson City, TNNTSB UNK64X2720Accident · No injuriesClosedSlingsby Lark 4 · Max, NE