NTSB investigations: Beech 1900D, 2004
4 cases on aircraft the registry lists as Beech 1900D. 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
| 1993 | 1 |
|---|---|
| 1994 | 2 |
| 1996 | 5 |
| 1997 | 4 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 4 |
| 2004 | 4 |
| 2005 | 4 |
| 2007 | 1 |
| 2008 | 1 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 2 |
| 2013 | 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\") = 2004
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1154162'))
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") = 2004
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1154162'))
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 CHI04IA178Incident · No injuriesIncident investigationFinal reportBeech 1900D · Milwaukee, WIThe fatigue fracture of the left main landing gear during landing roll.NTSB DEN04IA059Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver, COarcing of the windshield deicing system. Factors contributing to the incident were the improper inspection of the windshield's exterior seal, deterioration of the windshield seal, and water penetration through the deteriorated seal.NTSB NYC04LA099Accident · No injuriesLimited investigationFinal reportBeech 1900D · Windsor Locks, CTThe fuel truck driver's failure to maintain clearance with a taxiing airplane, resulting in the collision between the fuel truck and the airplane. A factor in the accident was the night condition.NTSB CHI04LA086Accident · No injuriesLimited investigationFinal reportBeech 1900D · Manhattan, KSThe captain's improper decision due to his attempt to taxi back onto the runway after coming to a stop in the grass, and the resulting collapse of nose landing gear. Contributing factors were the inoperative nose wheel steering, the pilot's inability to…