NTSB investigations: Beech 1900C, 1992
4 cases on aircraft the registry lists as Beech 1900C. 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
| 1970 | 1 |
|---|---|
| 1983 | 1 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 2 |
| 1991 | 1 |
| 1992 | 4 |
| 1994 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2007 | 1 |
| 2008 | 2 |
| 2010 | 2 |
| 2012 | 1 |
| 2013 | 1 |
| 2016 | 1 |
| 2018 | 1 |
| 2020 | 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 year(c.\"eventDate\") = 1992
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1154161'))
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 year(c."eventDate") = 1992
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1154161'))
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 DEN93LA011Accident · No injuriesLimited investigationFinal reportBeech 1900C · Denver, COThe ramp agent misjudging the clearance between the airplane and gpu. A factor was: unavailability of proper ground assistance.NTSB SEA92IA150Incident · No injuriesIncident investigationFinal reportBeech 1900C · Cheyenne, WYFailure of the fuel control unit on the left engine.NTSB FTW92IA104Incident · No injuriesIncident investigationFinal reportBeech 1900C · Lamar, COFailure of the pilot to maintain clearance. A factor was the bright sun.NTSB DCA92MA016Accident · 2 fatalMajor investigationFinal reportBeech 1900C · Gabriels, NYFailure of the captain to establish a stabilized approach, his inadequate cross-check of instruments, his descent below specified minimum altitude at the final approach fix, and failure of the copilot to monitor the approach. Factors related to the accident…